Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 27 Answers
- 27125 Views
- I also Faced
- E-Mail Answers
Answer Posted / cooldude
select max(sal) from Emp where sal < (select max(sal) from
Emp)
| Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
what is 'mysqld'? : Sql dba
How do you determine the current isolation level? : Transact sql
Name three sql operations that perform a sort.
Why are indexes and views important to an organization?
What is character functions?
Can we connect to postgresql using sql developer?
How do I count rows in sql?
First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
How to download oracle sql developer?
what are properties of a transaction? : Sql dba
What is the use of sqlerrd 3?
what is myisam? : Sql dba
What is spool?
What is a nested table in word?
What is a constraint?
