how to findout the 100th maximum salary

Answer Posted / raghuvir

select min(sal) from empl where romwnum < = 100 order by
sal desc

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why are indexes and views important to an organization?

679


What are predefined functions in sql?

712


Which is better stored procedure or query?

721


How many joins can you have in sql?

687


Explain what is a subquery ?

853






How do I find sql profiler?

683


How does rowid help in running a query faster?

1155


What is java sql package?

737


What is procedure explain with program?

722


How do you delete data from a table?

735


what is 'mysqld'? : Sql dba

706


What is meant by temporal data?

709


Why query optimization is needed?

683


What is the difference between microsoft access and sql?

725


What does <> sql mean?

712