Interested to Buy Any Domain ? << Click Here >> for more details...
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
Is microsoft sql free?
How can we avoid duplicating records in a query?
how can we know the number of days between two given dates using mysql? : Sql dba
What are stuff and replace function?
Can a varchar be a primary key?
Does sql require a server?
what is a tablespace? : Sql dba
What is difference between function and trigger?
What are the two different parts of the pl/sql packages?
What is record in pl sql?
What is data control language (dcl)?
What is sql trigger example?
What is the difference between sql and mysql?
Which operator is used in query for pattern matching?
Enlist the characteristics of pl/sql?
