Ask Question
Home > DeveloperSection > Interviews > Write an SQL SELECT statement to count the number of rows in STUDENT table and display the result with the label NumStudents.

Posted on    August-24-2014 11:53 PM

 MSSQL Server MSSQL Server 
Ratings:
 1 Answer(s)
  1021  View(s)
Rate this:
Sumit Kesarwani

Total Post:782

Points:3910
Posted on    August-24-2014 12:00 AM

SELECT COUNT(*) AS NumStudents FROM STUDENT;


report abuse

Don't want to miss updates? Please click the below button!

Follow MindStick

Copyright © 2010 - 2015 MindStick Software Pvt. Ltd. All Rights Reserved.