Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367466 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 are three advantages to using sql?
What is sqlca in powerbuilder?
What is the difference between null value, zero, and blank space?
What is difference between hql and native sql?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
What is difference between inner join and cross join?
How do I count rows in sql query?
What is pl sql in oracle?
Can I join the same table twice?
How do I pipe the output of one isql to another?
How does postgresql compare to mysql?
How do you determine the current isolation level? : Transact sql
Can we use ddl statements in stored procedure?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What is the difference between an inner and outer join?
