Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361394 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 / sagar padekar
select * from bill_gen
where total_payable< (select max(total_payable) from
bill_gen) order by total_payable desc limit 1;
hey please refer total_payable as salary amount
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is data definition language?
Is grant a ddl statement?
What are different clauses used in sql?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
what are the advantages and disadvantages of views in a database? : Sql dba
Who developed sql?
What is sql server and ase?
What does over partition by mean in sql?
Is sql microsoft?
What is the difference between instead of trigger and after trigger?
What is the purpose of the sql select top clause?
How do you remove duplicate records from a table?
What is trigger point?
Difference between table function and pipelined function?
Does truncate remove indexes?
