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
what is heap table? : Sql dba
How do you take the union of two tables in sql?
What can sql server reporting services do?
What is cold data?
What is a file delimiter?
How many types of tables are there?
Why do we need pl sql?
What is a Mapplet?
How do you optimize a stored procedure in sql?
How to download oracle sql developer?
Explain correlated query work?
what is cursor. write example of it. What are the attributes of cursor.
what is rdbms? : Sql dba
Is mariadb nosql?
what is the syntax for using sql_variant_property? : Transact sql