-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathWHERE.sql
329 lines (274 loc) · 22.2 KB
/
WHERE.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
--------------- WHERE Statement---------------------
------ Using the WHERE Clause
------Syntax:
SELECT column_name FROM table_name WHERE condition;
SELECT column_name(s) FROM table_name WHERE condition;
SELECT column_name FROM table_name WHERE condition(s);
SELECT column_name(s) FROM table_name WHERE condition(s);
--------------- WHERE Statement---------------------
-- SELECT All columns from the table employeedb, where WHERE Salary = 40000
SELECT * FROM employeedb WHERE Salary = 40000;
-- SELECT All columns from the table employeedb, where WHERE Salary > 40000
SELECT * FROM employeedb WHERE Salary > 40000;
-- SELECT All columns from the table employeedb, where WHERE Salary < 40000
SELECT * FROM employeedb WHERE Salary < 40000;
-- SELECT All columns from the table employeedb, where WHERE City = 'New York'
SELECT * FROM employeedb WHERE City = 'New York';
-- SELECT the column GENE_ID from the table rnaseq, where Gene_length=1000
SELECT GENE_ID FROM rnaseq WHERE Gene_length=1000;
-- SELECT the column GENE_ID from the table rnaseq, where Gene_length>1000
SELECT GENE_ID FROM rnaseq WHERE Gene_length>1000;
-- SELECT the column GENE_ID from the table rnaseq, where Gene_length<1000
SELECT GENE_ID FROM rnaseq WHERE Gene_length<1000;
-- SELECT the column Gene_Annotation from the table rnaseq
SELECT Gene_Annotation FROM rnaseq;
-- SELECT the column Expression_values from the table rnaseq WHERE Gene_length=2000;
SELECT Expression_values FROM rnaseq WHERE Gene_length=2000;
-- SELECT the column Expression_values from the table rnaseq WHERE Gene_length<2000;
SELECT Expression_values FROM rnaseq WHERE Gene_length<2000;
-- SELECT the column Expression_values from the table rnaseq WHERE Ge ne_length>2000;
SELECT Expression_values FROM rnaseq WHERE Gene_length>2000;
-- SELECT the column Expression_values from the table rnaseq WHERE Gene_length=3000;
SELECT Expression_values FROM rnaseq WHERE Gene_length=3000;
-- SELECT the column Gene_length from the table rnaseq WHERE RPKM >30000
SELECT Gene_length FROM rnaseq WHERE RPKM >30000;
-- SELECT the column Gene_length from the table rnaseq WHERE RPKM >20000
SELECT Gene_length FROM rnaseq WHERE RPKM >20000;
-- SELECT the column Gene_length from the table rnaseq WHERE RPKM >10000
SELECT Gene_length FROM rnaseq WHERE RPKM >10000;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM >10000
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM >10000;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM >12000
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM >12000;
-- SELECT column Gene_ID, Gene_Annotation, Unique_gene_reads from the table rnaseq WHERE RPKM >8000;
SELECT Gene_ID, Gene_Annotation, Unique_gene_reads FROM rnaseq WHERE RPKM >8000;
-- SELECT column Gene_ID, Gene_Annotation, Unique_gene_reads, Total_gene_read from the table rnaseq WHERE RPKM >5000 AND Gene_length >5000;
SELECT Gene_ID, Gene_Annotation, Unique_gene_reads, Total_gene_read FROM rnaseq WHERE RPKM >5000 AND Gene_length >1000;
-- SELECT column Gene_ID, Gene_Annotation, Unique_gene_reads, Total_gene_read from the table rnaseq WHERE RPKM >5000 AND Gene_length >5000;
SELECT Gene_ID, Gene_Annotation, Unique_gene_reads, Total_gene_read FROM rnaseq WHERE RPKM >5000 AND Gene_length >2000;
-- SELECT column Gene_ID, Gene_Annotation, Unique_gene_reads, Total_gene_read from the table rnaseq WHERE RPKM >5000 AND Gene_length >5000;
SELECT Gene_ID, Gene_Annotation, Unique_gene_reads, Total_gene_read FROM rnaseq WHERE RPKM >5000 AND Gene_length >3000;
-- SELECT column Gene_ID, Gene_Annotation, Unique_gene_reads, Total_gene_read from the table rnaseq WHERE RPKM >5000 AND Gene_length >5000;
SELECT Gene_ID, Gene_Annotation, Unique_gene_reads, Total_gene_read FROM rnaseq WHERE RPKM >5000 AND Gene_length >4000;
-- SELECT column Gene_ID, Gene_Annotation, Unique_gene_reads, Total_gene_read from the table rnaseq WHERE RPKM >5000 AND Gene_length >5000;
SELECT Gene_ID, Gene_Annotation, Unique_gene_reads, Total_gene_read FROM rnaseq WHERE RPKM >5000 AND Gene_length >5000;
-- SELECT the column RPKM from the table rnaseq WHERE Gene_length=3000;
SELECT RPKM FROM rnaseq WHERE Gene_length=3000;
-- SELECT columns Gene_ID, RPKM from the table rnaseq WHERE Gene_length=3000;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length=3000;
-- SELECT columns Gene_ID, Gene_Annotation, RPKM from the table rnaseq WHERE Gene_length=3000;
SELECT Gene_ID, Gene_Annotation, RPKM FROM rnaseq WHERE Gene_length=3000;
-- SELECT columns Gene_ID, Gene_Annotation, RPKM from the table rnaseq WHERE Gene_length>3000;
SELECT Gene_ID, Gene_Annotation, RPKM FROM rnaseq WHERE Gene_length<3000;
-- SELECT columns Gene_ID, Gene_Annotation, RPKM from the table rnaseq WHERE Gene_length>20000;
SELECT Gene_ID, Gene_Annotation, RPKM FROM rnaseq WHERE Gene_length>20000;
----------------Summary The WHERE Clause Operators----------------
--------- Operator Description Example
- = ------- Equal ---------
-- SELECT columns Gene_ID, RPKM from the table rnaseq WHERE Gene_length=3000;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length=3000;
-- SELECT columns Gene_ID, RPKM from the table rnaseq WHERE Gene_length=4000;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length=4000;
--- !=, <> -------------- Not equal
--- != ----------------- Not equal
-- SELECT columns Gene_ID, RPKM from the table rnaseq WHERE Gene_length!=400;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length!=400;
-- SELECT columns Gene_ID, RPKM from the table rnaseq WHERE Gene_length!=500;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length!=500;
--- <> ----------------- Not equal
-- SELECT columns Gene_ID, RPKM from the table rnaseq WHERE Gene_length<>400;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length<>400;
-- SELECT columns Gene_ID, RPKM from the table rnaseq WHERE Gene_length<>500;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length<>500;
-- SELECT columns Gene_ID, RPKM from the table rnaseq WHERE Gene_length<>1000;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length<>1000;
-- SELECT columns Gene_ID, RPKM from the table rnaseq WHERE Gene_length<>2000;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length<>2000;
-- SELECT columns Gene_ID, RPKM from the table rnaseq WHERE Gene_length<>3000;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length<>3000;
-- SELECT columns Gene_ID, RPKM from the table rnaseq WHERE Gene_length<>4000;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length<>4000;
-- SELECT columns Gene_ID, Gene_Annotation, RPKM from the table rnaseq WHERE Gene_length<>1000;
SELECT Gene_ID, Gene_Annotation, RPKM FROM rnaseq WHERE Gene_length<>1000;
-- SELECT columns Gene_ID, Gene_Annotation, RPKM from the table rnaseq WHERE Gene_length<>2000;
SELECT Gene_ID, Gene_Annotation, RPKM FROM rnaseq WHERE Gene_length<>2000;
-- SELECT columns Gene_ID, Gene_Annotation, RPKM from the table rnaseq WHERE Gene_length<>5000;
SELECT Gene_ID, Gene_Annotation, RPKM FROM rnaseq WHERE Gene_length<>5000;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM <>1000
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM <>1000;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM <>2000
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM <>2000;
-- SELECT column Gene_ID, Gene_Annotation, Unique_gene_reads from the table rnaseq WHERE RPKM <>3000;
SELECT Gene_ID, Gene_Annotation, Unique_gene_reads FROM rnaseq WHERE RPKM <>3000;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM <>4000
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM <>4000;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM <>5000
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM <>5000;
-- SELECT column Gene_ID, Gene_Annotation, Unique_gene_reads from the table rnaseq WHERE RPKM <>6000;
SELECT Gene_ID, Gene_Annotation, Unique_gene_reads FROM rnaseq WHERE RPKM <>6000;
---------- > --------------- Greater than
-- SELECT columns Gene_ID, RPKM from the table rnaseq WHERE Gene_length>400;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length>400;
-- SELECT columns Gene_ID, RPKM from the table rnaseq WHERE Gene_length>500;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length>500;
-- SELECT columns Gene_ID, RPKM from the table rnaseq WHERE Gene_length>1000;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length>1000;
-- SELECT columns Gene_ID, RPKM from the table rnaseq WHERE Gene_length>2000;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length>2000;
-- SELECT columns Gene_ID, RPKM from the table rnaseq WHERE Gene_length>3000;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length>3000;
-- SELECT columns Gene_ID, RPKM from the table rnaseq WHERE Gene_length>4000;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length>4000;
-- SELECT columns Gene_ID, Gene_Annotation, RPKM from the table rnaseq WHERE Gene_length>1000;
SELECT Gene_ID, Gene_Annotation, RPKM FROM rnaseq WHERE Gene_length>1000;
-- SELECT columns Gene_ID, Gene_Annotation, RPKM from the table rnaseq WHERE Gene_length>2000;
SELECT Gene_ID, Gene_Annotation, RPKM FROM rnaseq WHERE Gene_length>2000;
-- SELECT columns Gene_ID, Gene_Annotation, RPKM from the table rnaseq WHERE Gene_length>5000;
SELECT Gene_ID, Gene_Annotation, RPKM FROM rnaseq WHERE Gene_length>5000;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM >1000
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM >1000;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM >2000
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM >2000;
-- SELECT column Gene_ID, Gene_Annotation, Unique_gene_reads from the table rnaseq WHERE RPKM >3000;
SELECT Gene_ID, Gene_Annotation, Unique_gene_reads FROM rnaseq WHERE RPKM >3000;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM >4000
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM >4000;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM >5000
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM >5000;
-- SELECT column Gene_ID, Gene_Annotation, Unique_gene_reads from the table rnaseq WHERE RPKM >6000;
SELECT Gene_ID, Gene_Annotation, Unique_gene_reads FROM rnaseq WHERE RPKM >6000;
---------- < ---------- Less than ----------
-- SELECT columns Gene_ID, RPKM from the table rnaseq WHERE Gene_length<400;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length<400;
-- SELECT columns Gene_ID, RPKM from the table rnaseq WHERE Gene_length<500;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length<500;
-- SELECT columns Gene_ID, RPKM from the table rnaseq WHERE Gene_length<1000;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length<1000;
-- SELECT columns Gene_ID, RPKM from the table rnaseq WHERE Gene_length<2500;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length<2500;
-- SELECT columns Gene_ID, RPKM from the table rnaseq WHERE Gene_length<4000;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length<4000;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM <1000
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM <1000;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM <2000
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM <2000;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM <3000
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM <3000;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM <4000
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM <4000;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM <5000
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM <5000;
--------- >= Greater than or equal ------------------
-- SELECT columns Gene_ID, RPKM from the table rnaseq WHERE Gene_length>=400;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length>=400;
-- SELECT columns Gene_ID, RPKM from the table rnaseq WHERE Gene_length>=500;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length>=500;
-- SELECT columns Gene_ID, RPKM from the table rnaseq WHERE Gene_length>=800;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length>=800;
-- SELECT * from the table rnaseq WHERE Gene_length>=1000;
SELECT * FROM rnaseq WHERE Gene_length>=1000;
-- SELECT * from the table rnaseq WHERE Gene_length>=2000;
SELECT * FROM rnaseq WHERE Gene_length>=2000;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM >=1000
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM >=1000;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM >=2000
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM >=2000;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM >=3000
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM >=3000;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM >=4000
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM >=4000;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM >=6000
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM >=6000;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM >=500
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM >=500;
------------- <= ------------- Less than or equal -------------
-- SELECT columns Gene_ID, RPKM from the table rnaseq WHERE Gene_length<=400;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length<=400;
-- SELECT columns Gene_ID, RPKM from the table rnaseq WHERE Gene_length<=500;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length<=500;
-- SELECT columns Gene_ID, RPKM from the table rnaseq WHERE Gene_length<=800;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length<=800;
-- SELECT * from the table rnaseq WHERE Gene_length<=1000;
SELECT * FROM rnaseq WHERE Gene_length<=1000;
-- SELECT * from the table rnaseq WHERE Gene_length<=2000;
SELECT * FROM rnaseq WHERE Gene_length<=2000;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM <=1000
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM <=1000;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM <=2000
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM <=2000;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM <=3000
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM <=3000;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM <=4000
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM <=4000;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM <=6000
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM <=6000;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM <=500
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM <=500;
------------- ------------- Between -------------
-- SELECT columns Gene_ID, RPKM from the table rnaseq Gene_length BETWEEN 100 AND 400;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length BETWEEN 100 AND 400;
-- SELECT columns Gene_ID, RPKM from the table rnaseq WHERE Gene_length BETWEEN 200 AND 500;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length BETWEEN 200 AND 500;
-- SELECT columns Gene_ID, RPKM from the table rnaseq WHERE Gene_length BETWEEN 500 AND 1000;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length BETWEEN 500 AND 1000;
-- SELECT * from the table rnaseq WHERE Gene_length BETWEEN 200 AND 500;
SELECT * FROM rnaseq WHERE Gene_length BETWEEN 200 AND 500;
-- SELECT * from the table rnaseq WHERE Gene_length BETWEEN 200 AND 500;
SELECT * FROM rnaseq WHERE Gene_length BETWEEN 500 AND 750;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM > 1000; Tier #1 >1000
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM >1000;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM BETWEEN 250 AND 1000; Tier#2:250 - 1000
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM BETWEEN 250 AND 1000;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM BETWEEN 100 AND 250;Tier#3:100 - 250
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM BETWEEN 100 AND 250;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM BETWEEN 50 AND 100; Tier#4: 50 - 100
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM BETWEEN 50 AND 100;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM BETWEEN 25 AND 50; Tier#5: 25 - 50
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM BETWEEN 25 AND 50;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM BETWEEN 10 AND 25; Tier #6 10 - 25
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM BETWEEN 10 AND 25;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM BETWEEN 5 AND 10;Tier #7 5 - 10
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM BETWEEN 5 AND 10;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM BETWEEN 2.5 AND 5;Tier #8 2.5 - 5
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM BETWEEN 2.5 AND 5;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM BETWEEN 1 AND 2.5; Tier #9 1 - 2.5
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM BETWEEN 1 AND 2.5;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM BETWEEN 0 AND 1; Tier #10 0 - 1
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM BETWEEN 0 AND 1;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM=0; Tier #11 - 0
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM=0;
------------- ------------- NOT BETWEEN -------------
-- SELECT columns Gene_ID, RPKM from the table rnaseq Gene_length NOT BETWEEN 100 AND 400;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length NOT BETWEEN 100 AND 400;
-- SELECT columns Gene_ID, RPKM from the table rnaseq Gene_length NOT BETWEEN 200 AND 500;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length NOT BETWEEN 200 AND 500;
-- SELECT columns Gene_ID, RPKM from the table rnaseq Gene_length NOT BETWEEN 300 AND 600;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length NOT BETWEEN 300 AND 600;
-- SELECT columns Gene_ID, RPKM from the table rnaseq Gene_length NOT BETWEEN 500 AND 800;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length NOT BETWEEN 500 AND 800;
-- SELECT columns Gene_ID, RPKM from the table rnaseq Gene_length NOT BETWEEN 600 AND 1200;
SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length NOT BETWEEN 600 AND 1200;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM > 1000; Tier #1 >1000
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM >1000;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM NOT BETWEEN 250 AND 1000; Tier#2:250 - 1000
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM NOT BETWEEN 250 AND 1000;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM BETWEEN 100 AND 250;Tier#3:100 - 250
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM NOT BETWEEN 100 AND 250;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM NOT BETWEEN 50 AND 100; Tier#4: 50 - 100
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM NOT BETWEEN 50 AND 100;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM NOT BETWEEN 25 AND 50; Tier#5: 25 - 50
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM NOT BETWEEN 25 AND 50;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM NOT BETWEEN 10 AND 25; Tier #6 10 - 25
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM NOT BETWEEN 10 AND 25;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM NOT BETWEEN 5 AND 10;Tier #7 5 - 10
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM NOT BETWEEN 5 AND 10;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM NOT BETWEEN 2.5 AND 5;Tier #8 2.5 - 5
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM NOT BETWEEN 2.5 AND 5;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM NOT BETWEEN 1 AND 2.5; Tier #9 1 - 2.5
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM NOT BETWEEN 1 AND 2.5;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM NOT BETWEEN 0 AND 1; Tier #10 0 - 1
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM NOT BETWEEN 0 AND 1;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM=0; Tier #11 - 0
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM=0;
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM=0; Tier #11 - 0
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM=0;