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
Answer / ajit
Select Rn, ename
From ( Select Rownum rn, Ename
From Emp
)
Where Rn = Nth;
Is This Answer Correct ? | 1 Yes | 6 No |
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 |
What do you understand by case manipulation functions?
Why do we need cursors in pl sql?
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
what is a trigger in mysql? : Sql dba
What is ttitle and btitle?
What is indexing in sql and its types?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
What is the purpose of using pl/sql?
What is pseudo column ?
Why do we need databases?
what is explain plan?, given an example...