Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367642 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 / arvind
select max(salary) from table_name where sal<(select
max(salary) from table_name)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What happens when a trigger is associated to a view?
How can I delete duplicate rows?
How many primary keys can a table have?
Can 2 queries be executed simultaneously in a distributed database system?
What is varchar data type in sql?
What is auto increment feature in sql?
What is the difference between having clause and where clause?
Explain constraints in sql?
Which join is default?
What are the limitations of sql express?
What is cte?
What kind of join is join?
What is trigger in pl sql with examples?
explain primary keys and auto increment fields in mysql : sql dba
define sql insert statement ? : Sql dba
