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

select rownum as rowid,salary from (salary from employees
oderby salary )where rownum <2

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is a view? : Sql dba

1066


Which is better join or inner query?

1019


what happens if you no create privilege in a database? : Sql dba

982


What is the life of an sql statement?

1000


Why procedure is used in sql?

1026


Write the alter statement to enable all the triggers on the t.students table.

1112


How to run sql*plus commands in sql developer?

1133


When you have to use a default "rollback to" savepoint of plvlog?

1171


What is native sql query?

1005


What are the properties of a transaction?

1118


What are sql queries used for?

1008


What is difference between stored function and application function?

1173


Why partition by is used in sql?

1014


list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

953


What is pragma in pl sql?

1087