Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373156 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 / shiva kumar
select max(salary) from table01
where salary <(select max salary from table01)
in mainframe env
| Is This Answer Correct ? | 27 Yes | 13 No |
Post New Answer View All Answers
What are functions in sql?
how to use like conditions? : Sql dba
What is sorting in sql?
Is grant a ddl statement?
What is database migration?
Why are aggregate functions called so?
How to prepare for oracle pl sql certification?
What are different types of indexes?
what is meant by urlencode and urldocode? : Sql dba
Are views faster than queries?
What is the purpose of my sql?
Does mysql_real_escape_string prevent sql injection?
What are the indexing methods?
What are the advantages of stored procedure?
How to create an array in pl/sql?
