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
How show all rows in sql?
explain advantages of innodb over myisam. : Sql dba
Explain aggregate functions are available there in sql?
Explain the difference between sql and mysql.
List and explain the different types of join clauses supported in ansi-standard sql?
How do I run pl sql in sql developer?
How many types of cursors supported in pl/sql?
What are different types of keys?
What is normalisation and its types?
what are the join types in tsql? : Transact sql
What are the different dml commands in sql?
Is sql a dbms?
How do you modify a table in sql?
Why do we use view in sql?
Explain what is rdbms?
