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

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Next Question:
Where does hard drive save the bad sector count number?
Posted by:
hesham
02-February-2014

Computer Science

Question added by Emad Mohammed said abdalla , ERP & IT Software, operation general manager . , AL DOHA Company
Date Posted: 2014/12/18

Upvote (0) Views (5) Followers (1) Answers (1) Report Question

Write an Answer
Register now or log in to answer.

1 Answers

Emad Mohammed said abdalla

by Emad Mohammed said abdalla , ERP & IT Software, operation general manager . , AL DOHA Company

SELECT COUNT(*) AS NumStudents FROM STUDENT;

Downvote Reply () Report

Popular Searches

Sales Executive Jobs Engineers Jobs Engineering Technicians Jobs Accountant Jobs Driver Jobs

Write Your Answer

More Questions Like This

When a row of data is to be converted into columns
Top Answer: Right clik Copy then right click and choose transpose the fourth option under paste See More

Answers (7)
How to make views updateable in sql server?
Top Answer: The views in SQL Server are updateable by design. howerver there is some restrictions on th update operat ... See More

Answers (4)
Write an SQLSELECT statement to display all the columns of theSTUDENT table but only those rows where the Grade column is greater than or equal to 90.
Top Answer: <p>SELECT * FROM STUDENT WHERE Grade >=90;</p> See More

Answers (1)
Write sql a query to display the result 3rd maximum salary.
Top Answer: SELECT TOP1 salary FROM (SELECT TOP3 salary FROM Table_Name ORDER BY salary DESC) AS Q ORDER BY salary A ... See More

Answers (6)

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.