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 get second highest salary in SQL(as/4000

Answer Posted / sachin

select max(salary) from emp_salary where salary<(select
max(salary) from emp_salary);

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to display the records between two range in Oracle SQL Plus?

1196


How does cross join work?

1008


What are the possible values that can be stored in a boolean data field?

1042


Where can I learn sql for free?

1049


State some properties of relational databases?

1115


What is procedure and function in sql?

1045


How to download oracle sql developer?

1167


What is sqlca in powerbuilder?

1067


What is group by in sql?

1127


What type of join is sql join?

1023


What if we write return in procedure?

1513


Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1273


What is a sql trace file?

1085


Which software is used for pl sql programming?

1034


What is date functions?

1091