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

Question ajoutée par Emad Mohammed said abdalla , ERP & IT Software, operation general manager . , AL DOHA Company
Date de publication: 2014/12/18

Apprécier (0) Vues (4) Suiveurs (1) Réponses (1) Report Question

Ajoutez Une Réponse
Inscrivez-vous ou connectez-vous pour répondre.

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

SELECT COUNT(*) AS NumStudents FROM STUDENT;

Apprécier (0)

Déprécier Réponses () Rapport

Offres d'Emploi Ingénieur Offres d'Emploi Vendeur Offres d'Emploi Comptable Offres d'Emploi Informaticien Offres d'Emploi Technicien

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 Voir Plus

Réponses (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 ... Voir Plus

Réponses (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> Voir Plus

Réponses (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 ... Voir Plus

Réponses (6)