Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373310 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 / vinay
It works gr8...
select max(salary) from <table_name> where salary<(select
max(salary)from <table_name>)
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Which sql statement is used to delete data from a database?
What is string data type in sql?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
Why do we use procedures?
What is synchronized subquery?
What is difference between sql function and stored procedure?
What is the difference between left and left outer join?
Can you selectively load only those records that you need? : aql loader
What are the three forms of normalization?
When should I use nosql database?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
what is a composite primary key ? : Sql dba
what is a record in a database ? : Sql dba
Why do we need view in sql?
What are the two types of cursors in pl sql?
