Write an SQL SELECT statement to count the number of rows in STUDENT table and display the result with the label NumStudents.
216924-Aug-2014
Updated on 23-Sep-2020
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.
Sumit Kesarwani
24-Aug-2014SELECT COUNT(*) AS NumStudents FROM STUDENT;