To find second highest marks from student table

Satyapriyanayak
Posted by Satyapriyanayak under Sql Server category on | Points: 40 | Views : 926
select max(marks) from student where id not in(select max(marks) from student)

Comments or Responses

Login to post response