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
how to see the create table statement of an existing table? : Sql dba
What is the difference between explicit and implicit cursors in oracle?
How do you optimize a stored procedure query?
What is Difference Between Unique and Primary Key Constraints?
What is the largest value that can be stored in a byte data field?
what is the difference between myisam static and myisam dynamic? : Sql dba
What is insert command in sql?
How do I sort a table in sql?
how many groups of data types? : Sql dba
What is the difference between functions, procedures, and packages in pl/sql?
Write the command to remove all players named sachin from the players table.
Why do we create stored procedures & functions in pl/sql and how are they different?
What is sql entity?
Is sql a scripting language?
What is trigger types in sql?