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 / kishor dange

select max(sal) from table_name where sal<(select max(sal)
from table_name)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is primary key always clustered index?

1021


What is implicit cursor in pl sql?

1090


Can %notfound return null after a fetch?

1057


how can we find the number of rows in a table using mysql? : Sql dba

1083


What is a loop in sql?

982


Differentiate pl/sql and sql?

1062


What is localdb mssqllocaldb?

1066


What program will open a mdb file?

963


When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1115


How can you fetch first 5 characters of the string?

1018


What sql database should I use?

1139


What company owns postgresql?

1026


Can I join the same table twice?

1043


how to get a list of indexes of an existing table? : Sql dba

955


Explain exception handling in pl/sql?

1033