select * from bill_gen where total_payable< (select max(total

how to find the second highest salary from emp table?

Question Posted / sagar padekar

211 Answers
368279 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

Please Help Members By Posting Answers For Below Questions

What are all ddl commands?

1085

what is sp_pkeys? : Transact sql

1159

What is the primary use of normalization?

1004

What is the usage of distinct keyword?

1067

What is restrict in sql?

1120

How do you change a value in sql?

1019

Enlist the characteristics of pl/sql?

1803

What is null in pl/sql?

1072

Is left join faster than join?

1054

Can you load data into multiple tables at once? : aql loader

1066

How many databases can sql express handle?

987

What is pl sql block structure?

1037

What is a column in a table?

1126

How do I write a sql query in pgadmin 4?

988

How do I partition a table in sql?

1132