examples1

Queries from one table

-- show the contents of students table
SELECT * FROM students;
 
-- from how many cities the students are from?
SELECT COUNT(DISTINCT city) FROM students;
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License