Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
The_Learner
Starting Member
1 Post |
 Posted - 2014-10-05 : 22:28:25
|
| Hi Friends,I am a newbie to programming. Hence I only understand very basics. I want to SQL-query a database which was prepared using RSQLite which contains output of gene-differential-analysis. I am able to make simple queries but stuck with complex ones. For those who understand it, specifically I am trying to query RSQlite based cummeRbund which has a SQLite backend. The database is built on tables obtained for differential expression of genes. I have three samples (value_1, value_2, value_3) which are compared pairwise ( sample_1 vs sample_2) where, sample_1 and sample 2 can take any of the values i.e. value_1, value_2 or value_3. [b] I want to obtain a SQL query for only those values for gene_ids in column_1 where sample_1 column takes either of the values (value_1, value_2) but sample_2 column takes only value_3.[\b] Please help me.ThanksT_L |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-10-06 : 08:03:00
|
| This is a SQL server forum. YOu should probably post your question in a SQLite forum |
 |
|
|
|
|
|
RSQLite-Queries