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

Write a query to get 2nd maximum salary in an employee table ?

Answer Posted / wei

The best answer should be the first one, this is because
the sql statement accesses table emp only once.

Is This Answer Correct ?    9 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is dynamic sql in pl sql?

1038


Where can I learn sql for free?

993


What is the non-clustered index in sql?

1064


how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

976


how to use in conditions? : Sql dba

1014


Define union, minus, union all, intersect ?

1010


What is difference between stored procedures and application procedures?

1014


Is ms sql is free?

1025


ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2501


How can you tell the difference between an index and a view?

937


Can unique keys be null?

915


Name the different types of indexes in sql and define them.

1152


How do you pronounce sql?

1019


Can primary key be changed?

911


What are the syntax and use of the coalesce function?

1207