if i want to display the name of students such that to
which city they belong must have count greaer than two
- 1 Answers
- 2360 Views
- Atos Origin, I also Faced
- E-Mail Answers
Answer Posted / Dhirendra Singh
To achieve this in a database, you can use SQL's HAVING clause. Here's an example using MySQL:
SELECT student_name, city
FROM students
GROUP BY city
HAVING COUNT(student_name) > 2;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
