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
Explain the select statement in sql?
What is the difference between function and procedure in pl/sql?
How many functions are there in sql?
How do I order by ascending in sql?
What are all the different normalizations?
what is the command used to fetch first 5 characters of the string? : Sql dba
How to select 10 records from a table?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
Is sql developer case sensitive?
Can one improve the performance of sql*loader? : aql loader
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
What is ttitle and btitle?
What is the difference among union, minus and intersect?
What type of database is sql?
How do I view tables in mysql?
