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

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

More SQL PLSQL Interview Questions

What do you understand by case manipulation functions?

0 Answers  


Why do we need cursors in pl sql?

0 Answers  


suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.

7 Answers   Geometric Software, IBM,


How to Declare Fixed Length String Value In PL SQL

0 Answers  


what is a trigger in mysql? : Sql dba

0 Answers  


What is ttitle and btitle?

0 Answers  


What is indexing in sql and its types?

0 Answers  


How consistent is the view of the data between and within multiple sessions, transactions or statements ?

0 Answers  


What is the purpose of using pl/sql?

0 Answers  


What is pseudo column ?

6 Answers   ABB,


Why do we need databases?

0 Answers  


what is explain plan?, given an example...

3 Answers   Polaris,


Categories