Question

Which of the following is the correct syntax for a SELECT statement in SQLite?

a) SELECT columns FROM table WHERE condition ORDER BY column

b) SELECT table FROM columns WHERE condition ORDER BY column

c) SELECT columns FROM table ORDER BY column WHERE condition

d) None of the above

Answer 1

Answer: a) SELECT columns FROM table WHERE condition ORDER BY column

Explanation: The correct syntax for a SELECT statement in SQLite is SELECT columns FROM table WHERE condition ORDER BY column.