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 / premchand

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

Is This Answer Correct ?    34 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What trigger means?

1036


How do you use collections in procedure to return the resultset?

2286


What does subquery mean in sql?

1114


which operator is used in query for pattern matching? : Sql dba

1046


Can a table contain multiple foreign key’s?

1056


How long it takes to learn pl sql?

1067


Can you select everything, but 1 or 2 fields, without writer's cramp?

1040


What is the difference between Union and Union all. Which is faster.

1441


Why are aggregate functions called so?

1012


Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1072


What does sql stand for?

1055


What is varchar data type in sql?

1140


Define concurrency control. : Transact sql

1236


What is the use of sqldataadapter?

1027


What is the basic structure of an sql?

1159