adarsh pandey


{ City }
< Country > india
* Profession *
User No # 20478
Total Questions Posted # 0
Total Answers Posted # 1

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 2
Users Marked my Answers as Wrong # 1
Questions / { adarsh pandey }
Questions Answers Category Views Company eMail




Answers / { adarsh pandey }

Question { Temenos, 61311 }

I have student marks in a student table. I need second
highest mark .Then what will the query for this?


Answer

select distinct mark from student_mark s
where (select count(distinct s1.mark) from student_mark s1
where s1.mark>=s.mark )=4;

Is This Answer Correct ?    2 Yes 1 No