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...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Write a query to find second highest salary of an employee.

Question Posted / versaites

Answer Posted / versaites

select top 1 emp_total_sal,emp_name from (
select top 2 emp_total_sal,emp_name from employee_table
ORDER BY emp_total_sal DESC) a
ORDER BY emp_total_sal ASC

Is This Answer Correct ?    4 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the two virtual tables available at the time of database trigger execution?

1155

What is rownum and rowid?

982

How many triggers can be applied to a table?

992

What is sql*loader and what is it used for?

1042

Can ddl statements be used in pl/sql?

1065

What is the difference between a query and a report?

900

what is 'mysqldump'? : Sql dba

1046

Is progress software supports to ( pl/sql )?

968

Advantages and disadvantages of stored procedure?

1057

What is the difference between a subquery and a join?

1009

Explain polymorphism in pl/sql.

1055

How do I run pl sql in sql developer?

1056

what are the drivers in mysql? : Sql dba

981

Is grant a ddl statement?

849

What is the difference between numeric and autonumber?

938