Answer Posted / bindu
select * from (select rownum r1,e.* from emp e)
where r1=2;
Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
How can you fetch common records from two tables?
what is the difference between undefined value and null value? : Sql dba
what are the properties and different types of sub-queries? : Sql dba
Where can I learn sql for free?
Are sql database names case sensitive?
Why we use stored procedure instead of query?
Does oracle roll back the transaction on an error?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
What are the two virtual tables available at the time of database trigger execution?
How to change the order of columns in Oracle SQL Plus ?
Why are sql stored procedures used?
What are different functions in sql?
how to include character strings in sql statements? : Sql dba
what is the difference between a having clause and a where clause? : Sql dba
What does bitemporal mean?