+ 1
how can i calculate the number of students with age > x in sql?
4 Antworten
+ 3
SELECT COUNT(*) FROM students WHERE age > x
+ 9
Try:
SELECT COUNT(*) FROM STUDENTS WHERE AGE > x
+ 2
you can use alias as well for the count(*):
SELECT COUNT(*) AS 'Total Students' FROM students WHERE age > x
+ 1
SELECT COUNT(*) [TotalStudents] FROM students WHERE age > x