> > >

Transact-SQL (T-SQL) MCQs

Which query shows the first name, department, and team of all students with the two lowest points?

SELECT LIMIT(2) first_name, department, team FROM Students ORDER BY points ASC;

SELECT TOP(2) first_name, deprtment, team FROM Students ORDER BY points DESC;

SELECT TOP(2) WITH TIES first_name, department, team FROM Students ORDER BY points;

SELECT BOTTOM(2) first_name, department, team FROM Students ORDER BY points ASC;

Answer

Correct Answer: SELECT TOP(2) WITH TIES first_name, department, team FROM Students ORDER BY points;

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Transact-SQL (T-SQL) Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it

More Transact-SQL (T-SQL) MCQ Questions

Transact-SQL (T-SQL) Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it