Выведите лексикографически упорядоченный (по возрастанию) список имен преподавателей из базы STUDENTS&EXAM.
Какие варианты запросов верны?

Question

Выведите лексикографически упорядоченный (по возрастанию) список имен преподавателей из базы STUDENTS&EXAM. 
 Какие варианты запросов верны?

Accepted Answer

SELECT TeacherName FROM Teacher ORDER BY 1

Accepted Answer

SELECT TeacherName FROM Teacher ORDER BY TeacherName

Answer

SELECT * FROM Teacher ORDER BY 1

Answer

SELECT SORT TeacherName FROM Teacher

Answer

SELECT * FROM Teacher ORDER BY 2

Answer

SELECT TeacherName FROM Teacher ORDER BY 2

Answer

SELECT TeacherName FROM Teacher SORT BY TeacherName

Crowdly