1. Queris for Nth maximum Nth row?

Select * from (select column_name1 column_name1 from table_name order by column_name) where rownum < N

2. In One table there are 5 fields. empno ename deptcd managr_id salary.
Select the departments whoose sum of the salary greater than the sum of salaries of any department?

Select deptcd sum(salary) from table_name group by deptcd orderby salary desc

3. When index will be usd in the Query?
Index is used by the Optimizer when a query is fired in Oracle.

how to find starting letters in names in sql query

e.g sachin tendulkar

i want to display S & T in this name

write the query hike the sal of employee

1 year experence 10

less than one year experence 5

select salary

from (select rownum rank salary

from ( select salary f

rom emp order by salary desc))where rank &N
/

select salary

from(select rownum rank salary

from ( select salary

from emp order by salary desc))

where rank &N
/

this should do the job . . . exactly what you are asking