0
I' m trying to find names of students who got same rank,i need query please Thanks in advance
i have Student table with respective columns::::: Student names: A,B,C,D,E Mark's:100,200,100,300,200 Rank:3,2,3,1,2 expected result: Student names marks rank A 100 3 C 100 3 B 200 2 E 200 2
3 Respostas
+ 1
vijay ,
sorting records based on marks field will give desired result.
SELECT student_name , marks, rank FROM student ORDER BY rank;
+ 1
vijay ,
You are welcome.
I can directly tell you query but that will not actually help you to learn. This looks more of homework to me.
I'll just provide a hint now.
Observe the desired output carefully. It has all records which have `marks` less than 300.
You can easily modify previous query to get necessary output .
Use where class to add a condition on select statement.
Try to learn on your own first. your efforts matter more than anything else.
https://www.tutorialspoint.com/sql/sql-where-clause.htm
0
Thanks Omkar, I have modified my expected result,can you look at it again