Answer Posted / vamsi krishna
this query will give the correct answer.
all the answers which are given above are absolutely wrong.
(take it easy who posted them)
select * from (select rownum as r1,empno,ename,sal,deptno
from emp) where r1=2;
(take default emp table for execution)
| Is This Answer Correct ? | 12 Yes | 8 No |
Post New Answer View All Answers
Explain the uses of control file.
What is sqlexception in java?
How many sectors are in a partition?
What are the dml statements?
Which sorts rows in sql?
what is an extent ? : Sql dba
what are the different index configurations a table can have? : Sql dba
Difference between global and parameter variables?
what are the different functions in sorting an array? : Sql dba
how to start mysql server? : Sql dba
Explain what is an index?
Do we need commit after truncate?
What is the primary key?
what are the limitations of identity column? : Transact sql
Is clustered index a primary key?