Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary in a given table????
- 5 Answers
- 8714 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 would you change old and new values in an insert, delete and update triggers?
What are the different windows events activated at runtime ?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
What are triggers in oracle?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What are the common oracle dba tasks?
Can a formula column be obtained through a select statement ?
How to assign a table row to a record variable?
what is the difference between data migration and production migration.
What is an oracle user role?
How to start a specific oracle instance?
Why is oracle used?
How to assign a tablespace to a users in oracle?
