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)
  872  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;


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

Follow MindStick