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
Does inner join remove duplicates?
What is delimiter sql?
what is “go” in t-sql? : Transact sql
Is full outer join same as cross join?
What is the difference between join and natural join?
What company owns postgresql?
What are triggers and its types?
Write an sql query to select all records from the table?
What is a primary key? Explain
What is blind sql injection?
What is full join in sql?
Why self join is used in sql?
What is query optimization in sql?
how can you see all indexes defined for a table? : Sql dba
Explain the uses of a database trigger?