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 calcuate the second highest salary of he employee

Answer Posted / vivek ghorad

select min(select top(2)salary from emp)from emp;

Is This Answer Correct ?    3 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can I join the same table twice?

1058


What is inner join in sql?

1091


How do I remove all records from a table?

1086


What is meant by user defined function?

1059


What are the different types of triggers?

1144


Explain the purpose of %type and %rowtype data types?

941


What are the types of dbms?

982


Is primary key an index?

1000


Why do we use sql constraints? Which constraints we can use while creating database in sql?

1048


what is a constraint? : Sql dba

1186


Define SQL and state the differences between SQL and other conventional programming Languages?

1227


Determine if oracle date is on a weekend?

1052


What is pl sql block structure?

1046


What is the difference between the conventional and direct path loader? : aql loader

1158


What is basic structure of pl sql?

1079