Answer Posted / vamsi nukala
select * from(select rownum as rno,emp.* from emp)where rno=2;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is a constraint? Tell me about its various levels. : Sql dba
How can we make an if statement within a select statement?
How many row comparison operators are used while working with a subquery?
What is the difference between an inner and outer join?
What is recursive stored procedure?
How many indexes can be created on a table in sql?
What are the ways on commenting in a pl/sql code?
what is a record in a database ? : Sql dba
What is the sql*loader? : aql loader
What is sharding in sql?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
how to do backup entire database? : Transact sql
What is the default isolation level in sql server? : Transact sql
what is an alias command? : Sql dba
How do I partition in sql?