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 >> Databases AllOther
  2. Suggest New Category

write a query for the fifth highest salary?

Question Posted / ramesh

Answer Posted / ramesh

select top 1 salary

(select distinct top 5

salary from employees

order by salary desc)

a order by salary

Is This Answer Correct ?    6 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What advantages does DBMS have over traditional file systems?

1081

What the various ways to tune a teradata query

3331

how to configure oracle 10g in java1.5 and tell me know how to set class path in system?

2081

Explain partial key?

1141

how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)

2102

How concurrency problems effect the database?

1209

Explain buffer manager?

991

What is ole db used for?

1065

Is it good to store images in database?

1050

HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?

2699

What is a database lookup?

1136

What is a database string?

996

There are three servers are run by Oracle, MS Access and .Net. What are the procedure fetching the values of two variables from two servers among these?

2210

What is the purpose of firebase?

1030

How many types of normalization? What is the use of it?

1186