Consider the following relation:

Student $($StudentNum$,$ serialnum, marks$)$

The query is to display student details who got second highest marks are:

select $*$ from student $$1$ where $2=($select count$($s$2.$marks$)$ from student $s2$ where $s1.$marks $s2.$marks$)$;

select $*$ from student $s1$ where select count$($s$2.$marks$)$ from student $s2$ where $s1.$marks $s2s1$