Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary in a given table????
- 5 Answers
- 8476 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 convert a date to char in oracle? Give one example.
What is the usage of analyze command in oracle?
How to Truncate Table in Oracle
What is the difference between alert log file and tarce file ?
How to create a new tablespace in oracle?
What is the difference between a hot backup and a cold backup in oracle?
How to define an anonymous procedure with variables?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
WHAT IS ecc 6.0
Explain view?
Explain oracle insert into command?
Explain the blob datatype?
What is a data dictionary and how can it be created?
What is the disadvantage of User defind function?
Explain the dml?
