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
What is coalesce in sql?
How does one load ebcdic data? : aql loader
What is pls_integer in pl sql?
Is json a nosql?
What is the use of partition by in sql?
What is procedure and function?
What is a file delimiter?
Is join and inner join the same?
How can we implement rollback or commit statement in a trigger?
how to install mysql? : Sql dba
How do you modify a column in sql?
Define implicit and explicit cursors.
Explain 3 basic parts of a trigger.
What is the advantage of nosql?
Can you call pl/sql package functions from within a fast formula?