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
Can we insert in view in sql?
Does truncate need commit?
What is trigger in flip flop?
what is log shipping? : Sql dba
How to run sql statements through the web interface?
What are the types of records?
How can you fetch first 5 characters of the string?
What is group function in sql?
How do you update a sql procedure?
What does desc stand for?
What does plv msg allows you to do?
define sql delete statement ? : Sql dba
What is inner join in sql?
Is id a reserved word in sql?
Is sql a backend?