The table Comments has an auto incremented column called 'Commentid' and a 'UserComments' column, both of which store the comments of the users visiting the site. What will be the correct query to display the latest comments first? - Microsoft SQL Server

> > >

Microsoft SQL Server MCQs

The table Comments has an auto incremented column called "Commentid" and a "UserComments" column, both of which store the comments of the users visiting the site. What will be the correct query to display the latest comments first?

Select usercomments From Comments Order by commentid

Select usercomments From Comments Order by commentid desc

Select usercomments From Comments Order by usercomments

Select usercomments From Comments Order by usercomments desc

Answer

Correct Answer: Select usercomments From Comments Order by commentid desc

Explanation:

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

Microsoft SQL Server Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it