SQL Basics

Question 1

SELECT * FROM tbl

Answer 1

Select all rows and columns from table tbl

Question 2

SELECT c1, c2 FROM tbl

Answer 2

Select column c1, c2 and all frows from table tbl

Question 3

SELECT c1, c2 FROM tbl
WHERE conditions
ORDER BY c1 ASC, c2 DESC

Answer 3

Select columns c1, c2 with where conditions and from table tbl order result by column c1 in ascending order and c2 in descending order