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 the difference between inner join and natural join?

1053


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

1179


What is server name sql?

1202


How do you run a query?

1049


How delete all data from all tables in sql?

982


What are actual parameters and formal parameters?

1168


what are the advantages and disadvantages of cascading style sheets? : Sql dba

1101


what is transaction? : Sql dba

1058


How to return multiple rows from the stored procedure?

1014


What is the difference between nested table and varray?

1049


What are different clauses used in sql?

1172


what are numeric data types? : Sql dba

1108


Why having clause is used in sql?

1019


Why do we use view in sql?

1017


What is the difference between function, procedure and package in pl/sql?

1349