How to get only one row in sql having count of one column in that table is >10 to be given in where condition | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 2

How to get only one row in sql having count of one column in that table is >10 to be given in where condition

eg. table- ABC, columns - marks,student_name. I want anyone student name whose Marks are >530

14th May 2018, 5:03 PM
mallika
2 Answers
0
Im not an expert but you can use something like this Select marks, students_name where (Select count(marks) >530)
15th May 2018, 2:04 AM
Juan Antonio Ortiz
Juan Antonio Ortiz - avatar
0
Right now
28th May 2018, 10:10 PM
Michael Benzema