I have a table .in the table 100 recored is there .we have get the single row

I have a table .in the table 100 recored is there .we have
get the single row with out using clause..

Question Posted / prasad

3 Answers
8519 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I have a table .in the table 100 recored is there .we have get the single row with out using claus..

Answer / ajit

Select Rn, ename
From ( Select Rownum rn, Ename
From Emp
)
Where Rn = Nth;

Is This Answer Correct ?

1 Yes

6 No

I have a table .in the table 100 recored is there .we have get the single row with out using claus..

Answer / prasad

Please give Fast

Is This Answer Correct ?

0 Yes

9 No

I have a table .in the table 100 recored is there .we have get the single row with out using claus..

Answer / nannesaheb chinthalacheruvu

Question is not clear..kindly elaborate the same.

As i understand is "Retrive the single row with out using the where clause"...if so the below query may help you to achive the same.

Select e.*,max(rowid) from emp e;

select e.*,min(rowid) from emp e;

Is This Answer Correct ?

2 Yes

14 No

Post New Answer