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 / velmurugan p

Select min(sal) from table_name where sal in(Select top 2 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

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

947


what is the command used to fetch first 5 characters of the string? : Sql dba

1585


Are subqueries faster than joins?

950


What is partition in sql query?

947


What is dense_rank in sql?

916


Does a primary key have to be a number?

916


How to pronounce postgresql?

1006


What is int identity in sql?

1060


Explain architecture of sql server notification services?

985


What is normalisation and its types?

955


how would you get the current date in mysql? : Sql dba

912


Which certification is best for sql?

938


How to check if a column is nullable before setting to nullable?

1055


What is the primary use of normalization?

941


What is the use of function in sql?

1028