Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368187 Views
- CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
- E-Mail Answers
Answer Posted / jayshree
select max(sal) from table_name where sal not in (select
max(sal) from table_name)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
What is indexes?
Explain the purpose of %type and %rowtype data types with the example?
How does sql profiler work?
What is autocommit sql?
What is data manipulation language?
Why schema is used in sql?
how can we know the count/number of elements of an array? : Sql dba
Is sql a dbms?
What is auto increment feature in sql?
Can pl sql procedure have a return statement?
Which is better trigger or stored procedure?
what is cursor. write example of it. What are the attributes of cursor.
How to call shell script from pl sql procedure?
What is the difference between nested table and varray?
