Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / anu
select *
FROM (select emp1.* ,rownum rnum
from ( select * from emp order by sal_amount desc ) emp1
where rownum<=3)
where rnum >=3
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can a varchar be a primary key?
What is vector point function?
Write a sql query to convert all character to uppercase after hypen.
What is trigger and how to use it in sql?
How many joins can you have in sql?
What is a unique key?
Can we create index on primary key?
List and explain the different types of join clauses supported in ansi-standard sql?
What is the difference between python and sql?
Why truncate is faster than delete?
What is scalar and vector?
If a cursor is open, how can we find in a pl/sql block?
What are the syntax and use of the coalesce function?
how to use myisamchk to check or repair myisam tables? : Sql dba
what is a trigger in mysql? : Sql dba
