nom-sql/tests/select.txt at cadac57b69ec250c710762eda0e65b03b3d497ac · ms705/nom-sql · GitHub

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
select * from;

select a + b from c;
select a + 2 from c;
select a+ 2 from c;
select a+2 from c;

select a from db1.table1;
select table1.a from db1.table1;
select table1.a from db1.table1 as d;

SELECT n+10 FROM tens WHERE n+10 >= 100;
SELECT n+10 FROM tens WHERE n+10 < 100;
SELECT n+10 FROM tens WHERE n+10 > 100;
SELECT n+10 FROM tens WHERE n+10<= 100;
SELECT n+10 FROM tens WHERE n+10 = 100;

SELECT n+10 FROM tens WHERE (n+10) >= 100;
SELECT n+10 FROM tens WHERE (n+10 )< 100;
SELECT n+10 FROM tens WHERE (n+10) > 100;
SELECT n+10 FROM tens WHERE (n+10 )<= 100;
SELECT n+10 FROM tens WHERE ( n+10 ) = 100;

SELECT n+10 FROM tens WHERE 100 >= (n+10);
SELECT n+10 FROM tens WHERE 100 >(n+10 ) ;
SELECT n+10 FROM tens WHERE 100<( n+10) ;
SELECT n+10 FROM tens WHERE 100>=(n+10 ) ;
SELECT n+10 FROM tens WHERE 100 = ( n+10 );

SELECT n+10 FROM tens WHERE n >= 100;
SELECT n+10 FROM tens WHERE n <100;
SELECT n+10 FROM tens WHERE n >100;
SELECT n+10 FROM tens WHERE n<= 100;
SELECT n+10 FROM tens WHERE n= 100;