Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how to find the second highest salary from emp table?

Answer Posted / anantkreshna v

select max(sal) from emp_table where sal < (select max(sal)
from emp_table);

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how can we know the number of days between two given dates using mysql? : Sql dba

1090


Is left join inner or outer by default?

1074


Can we rollback delete command?

1039


What is bind variable in pl sql?

1106


What is sql rowcount?

1073


Is a foreign key always unique?

984


What is sql deadlock?

1219


how to create a test table in your mysql server? : Sql dba

1057


What is the difference between the conventional and direct path loader? : aql loader

1195


What is sql stand for?

1033


Explain the working of foreign key?

1137


How can we link a sql database to an existing android app?

1080


What is benefit of creating memory optimized table?

1034


What is the difference between sum and count in sql?

1039


Can we commit inside a trigger?

1048