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

write a query for the fifth highest salary?

Answer Posted / chethan

select Salary from ( select salary from emp order by desc) as employee where rownum = 5;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9

1792


What is the function of cluster index?

1221


wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..

3168


how can we view column head in first page but not in remaining pages?

2080


What is redis good for?

1002


Data structure used to implements a menu:

1216


hai if any one having any project sample table structure please froward to my mail id tauseefwst@yahoo.com

2442


What are the advantages of using database?

1057


What do you mean by cluster and non cluster index?

1128


Differentiate between unique key and foreign key?

1069


What is the DIF format and when we will use in teradata

2539


What is the use of default key?

1217


can we delete autodiff back up that we have set through sql server agent.

2252


HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?

2699


Explain database partitioning.

1124