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 row_number () in sql?
What is pl sql variable?
what are dynamic queries in t-sql? : Transact sql
Explain the difference between drop and truncate commands in sql?
What is asqueryable?
how to use 'mysql' to run sql statements? : Sql dba
Why do we need view in sql?
Is postgresql a server?
What are the different type of joins in sql?
What can I use instead of union in sql?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
Which join condition can be specified using on clause?
Can one improve the performance of sql*loader? : aql loader
What are the built in functions of sql?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?