Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary in a given table????
- 5 Answers
- 8877 Views
- I also Faced
- E-Mail Answers
Answer Posted / kedar
select max(salary) from employees where salary < (select
max(salary) from employees);
the max salary is 24000
& second max is 17000
chwck out
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How to define a cusotmer as a supplier in ORACLE R12
How to shutdown your 10g xe server from command line?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
What is the difference between sharding and replication?
How to use values from other tables in update statements using oracle?
Respected sir, Please send me technical questions related to oracle apps..
What are the different types of synonyms?
How to use subqueries with the in operator using oracle?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
How to rename an index?
What is partitioned table in Oracle?
How many types of synonyms in Oracle?
What is merge in oracle?
What are the predefined tablespaces in a database?
