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

Why having clause is used in sql?

1025


What is t sql used for?

1066


What is the sql query to display the current date?

1101


What is the difference between partition and index?

1070


Compare sql & pl/sql

1222


What is acid property in a database?

1090


what are the different type of sql's statements ? : Sql dba

984


How do you declare a variable in pl sql?

1077


What is the difference between delete, truncate and drop command?

1237


Is left join and outer join same?

1125


What is sql comments?

1121


what is bcp? When does it used? : Sql dba

1038


Explain the rollback statement?

1075


What are the types of index in sql?

1129


When do we use triggers?

1155