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...

find out the third highest salary?

Answer Posted / ayaz mahmood

select max(sal) from emp
where sal= (select max(sal) from emp
where sal< (select max(sal) from emp
where sal< (select max(sal) from emp)))

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to handle exceptions in post production

1426


Please explain joins in oracle?

1062


What is meant by an index?

1145


Can a formula column be obtained through a select statement ?

2324


How to insert a record into a table?

1070


What is a system tablespace?

1072


What is the difference between a hot backup and a cold backup in oracle?

1015


What is the sql query to concatenate column values from multiple rows in oracle?

1056


What are the differences between number and binary_float in oracle?

1100


What is the recommended interval at which to run statspack snapshots, and why?

2919


What is proxy method?

972


What is the use of file param in imp command?

1165


what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2467


What is a snapshot log?

1003


Can we write dml statement in function in oracle?

1081