write a query to display the third record from the employee table?

write a query to display the third record from the employee
table?

Question Posted / sekhar

Answers were Sorted based on User's Feedback

write a query to display the third record from the employee table?..

Answer / m m naidu

To display the 3rd record of emp table we can write query as
select * from emp where rownum<4 minus select * from emp
where rownum<3;

Is This Answer Correct ?

6 Yes

1 No

write a query to display the third record from the employee table?..

Answer / srinu

select * from (select rownum r,emp.* from emp) where r=3;

Is This Answer Correct ?

3 Yes

1 No

write a query to display the third record from the employee table?..

select * from emp e where 3=(select count(sal) from emp
where e.sal>sal)

Is This Answer Correct ?

3 Yes

2 No

write a query to display the third record from the employee table?..

Answer / i.anil

select a.*,rownum from
(select b.*,rownum rk from
(select * from emp )b)a where rk=3;

Is This Answer Correct ?

1 Yes

0 No

write a query to display the third record from the employee table?..

Answer / vsandhyana

select top 1 * from (select top 3 * from employee order by
employeeid desc) emp

Thanks
Vsandhyana

Is This Answer Correct ?

0 Yes

0 No

write a query to display the third record from the employee table?..

Answer / ammu

select * from emp e where 4=(select count(sal) from emp
where e.sal>sal)

Because it follows n-1 rule..

Is This Answer Correct ?

0 Yes

0 No