Skip to content

Latest commit

 

History

History
18 lines (17 loc) · 563 Bytes

sample_queries.md

File metadata and controls

18 lines (17 loc) · 563 Bytes

Example queries

  1. select * from table1
  2. select max(A) from table1
  3. select min(B) from table1
  4. select avg(C) from table1 5.select sum(D) from table2
  5. select A from table1 7.select A,D from table1,table2 8.select distinct(C) from table3
  6. select B,C from table1 where A=-900
  7. select A,B from table1 where A=775 OR B=803
  8. select A,B from table1 where A=922 OR B=158;
  9. select * from table1,table2 where table1.B=table2.B
  10. select A,D from table1,table2 where table1.B=table2.B
  11. Select A from table4;
  12. Select Z from table1;