Answer Posted / katasani rajesh reddy
select salary from(select salary from
order by salary)
where rownum<=100
minus
select salary from(select salary from
order by salary)
where rownum<=99
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
How to assign sql query results to pl sql variables?
Difference between table function and pipelined function?
what is difference between delete and truncate commands? : Sql dba
what is user defined functions? : Sql dba
Does google use sql?
What are dml commands?
How to rename a table?
What is the difference between local and global temporary table?
What packages(if any) has oracle provided for use by developers?
What are the steps for performance tuning.
What is difference between cursor and trigger?
How do you bind variables in pl sql?
What are different functions in sql?
What is pl sql script?
How can we optimize a sql query?