WRITE AN SQL SELECT STATEMENT TO COUNT THE NUMBER OF ROWS IN STUDENT TABLE AND DISPLAY THE RESULT WITH THE LABEL NUMSTUDENTS.

Sumit Kesarwani

Total Post:782

Points:3910
Posted by  Sumit Kesarwani
 1117  View(s)
Ratings:
Rate this:
  1. Sumit Kesarwani

    Post:782

    Points:3910
    Write an SQL SELECT statement to count the number of rows in STUDENT table and display the result with the label NumStudents.

    SELECT COUNT(*) AS NumStudents FROM STUDENT;

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!