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 do you tune the slow running queries in oracle db , explain the methodology
What is pivot in sql?
Why we use joins in sql?
what is auto increment? : Sql dba
What is a temporal data type?
What is full join?
discuss about myisam key cache. : Sql dba
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
how to create a new table in mysql? : Sql dba
What is a Mapplet?
Why we use cross join?
What is a left inner join?
How can I make sql query run faster?
Why commit is not used in triggers?
What is the advantage of nosql?