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 / bharat puri

select top 2 (salary) from emp
order by salary desc

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the maximum number of columns in sql table?

1167


What is attribute indicator in pl sql?

1011


Can I learn sql in a week?

1059


Is vs as in pl sql?

984


How many triggers can be applied to a table?

1057


how can we know the count/number of elements of an array? : Sql dba

1060


Why schema is used in sql?

1047


What is the purpose of design view?

1005


what are enums used for in mysql? : Sql dba

1168


How do you update sql?

965


Which function is used to return remainder in a division operator in sql?

1135


Is the primary key an index?

1025


What is a mutating table and a constraining table?

1107


Give the order of sql select?

1133


What do you think about pl/sql?

1026