Search:

Hi,
could any one please tell me how to display the higest salaries in between two numbers.
suppose say...display from 2nd highest salary to 5th highest salary from a table.
please clarify this

Hi,
Please clarify how does the output of one is a single record/row and how does the output of
the second one is multiple records/rows

Let us consider emp table in Oracle

i wrote
...

could you please explain me how does the below work. suppose in a situation we have a table called jobhistory where, we have values in salary column as (3000,4000,5000,6000,7000)
so in order to...

Could you please explain how the count function works here? question)sql query to get 4th or 5th maximum value from a table ans: select * from jobhistory x where (5=(select count(distinct(y.salary))...