> > >

Transact-SQL (T-SQL) MCQs

To select a random student from the table, which statement could you use?

SELECT TOP(1) first_name, last_name FROM Students ORDER BY NEWID();

SELECT TOP(1) RAND(first_name, last_name) FROM Student;

SELECT TOP(1) first_name, last_name FROM Student;

SELECT TOP(1) first_name, last_name FROM RAND(Student);

Answer

Correct Answer: SELECT TOP(1) first_name, last_name FROM Students ORDER BY NEWID();

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