Interested to Buy Any Domain ? << Click Here >> for more details...
find out the second highest salary?
- 55 Answers
- 89732 Views
- Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
- E-Mail Answers
Answer Posted / ananth
this is for 2nd highest sal in sql server database
select * from emp where sal=(select max(sal) from emp where
sal<(select max(sal) from emp))
| Is This Answer Correct ? | 119 Yes | 13 No |
Post New Answer View All Answers
How to delete an existing row from a table in oracle?
Use of an integrity constraint is better to validate data. Explain
What is meant by raw datatype?
What happens to the current transaction if the session is killed?
How to load data through external tables?
How to return top 5 rows in oracle?
How to name query output columns in oracle?
Explain about your project and its relation to the current job position you are applying to?
How to apply filtering criteria at group level in oracle?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
Explain the use of tables option in exp command.
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
What are a query and state the different types of queries and their uses?
How to define a procedure inside another procedure?
What is an oracle table?
