> > >

Transact-SQL (T-SQL) MCQs

Given a table with the following structure, which query returns all student names with the highest grade? CREATE TABLE Students (StudentName varchar(50),Grade int );

SELECT StudentName FROM Students WHERE Grade = MAX(Grade);

SELECT TOP(1) StudentName FROM Students ORDER BY Grade;

SELECT TOP(1) WITH TIES StudentName FROM Students ORDER BY Grade DESC;

SELECT StudentName, MAX(Grade) FROM Students ORDER BY Grade DESC;

Answer

Correct Answer: SELECT TOP(1) WITH TIES StudentName FROM Students ORDER BY Grade DESC;

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