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

4 Answers
7388 Views
HCL, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / krishna

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 ?

9 Yes

0 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 ?

6 Yes

3 No

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

Answer / kumar

select * from emp where rownum<4 minus select * from emp
where rownum<3;

Is This Answer Correct ?

1 Yes

1 No

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

Answer / g.arangarasu

No friends,

rownum is one of the column name of table like
emp_no,emp_name etc. if u have not rownum column in ur
table,how to solve it.

we can retrieve this record through physical location that
is using rowid not rownum.

select min(rowid) from emp not in(select min(rowid) from
emp not in(select min(rowid) from emp));

Is This Answer Correct ?

1 Yes

1 No

Post New Answer