---
title: "Write an SQL SELECT statement to count the number of rows in STUDENT table and display the result with the label NumStudents."  
description: "Write an SQL SELECT statement to count the number of rows in STUDENT table and display the result with the label NumStudents."  
author: "Sumit Kesarwani"  
published: 2014-08-24  
updated: 2020-09-23  
canonical: https://www.mindstick.com/interview/1990/write-an-sql-select-statement-to-count-the-number-of-rows-in-student-table-and-display-the-result-with-the-label-numstudents  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# 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;

## Answers

### Answer by Sumit Kesarwani

SELECT COUNT(*) AS NumStudents FROM STUDENT;


---

Original Source: https://www.mindstick.com/interview/1990/write-an-sql-select-statement-to-count-the-number-of-rows-in-student-table-and-display-the-result-with-the-label-numstudents

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.