I have a table .in the table 100 recored is there .we have
get the single row with out using clause..
Answer Posted / ajit
Select Rn, ename
From ( Select Rownum rn, Ename
From Emp
)
Where Rn = Nth;
Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
Show the two pl/sql cursor exceptions.
Explain spool.
How do we accept inputs from user during runtime?
What is a null value?
What is the difference between a procedure and a function?
How does cross join work in sql?
How do I order by ascending in sql?
Do we need to rebuild index after truncate?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
Can sql developer connect to db2?
How do I run sql?
Explain the methods used to protect source code of pl/sql.
What is a parameter query?
What is minus?
Will truncate release space?