Question

To display the records of students in alphabetical order by their names, which one is correct -
1 SELECT * FROM STUDENTS IN ORDER BY NAME;
2 SELECT * FROM STUDENTS ORDER BY NAME;
3 SELECT * FROM STUDENTS ORDER BY NAMES DESC;
4 ORDER BY NAME SELECT ALL RECORDS;​

Answer 1

Answer:

option one and two is correct

Answer 2

Answer:

2. SELECT * FROM STUDENTS ORDER BY NAME;

Explanation:

as we have to show name in alphabetical order