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 >> Data Warehouse >> Cognos
  2. Suggest New Category

Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?

Question Posted / vsandhyana

Answer Posted / vsandhyana

select top 1 * from (select top 5 * from customers order by
salary desc) a order by salary asc

Thanks
Vikram Sandhyana

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the themes in a data warehouse?

1008

Explain the difference between powerplay transformer and power play reports?

985

What are shortcuts? Where it can be used? What are the advantages?

1025

What is the importance of having monitor service in cognos?

1005

HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks

1898

Can you define materialized view?

1008

-------------What is Coditional Prompting?

2109

hi my name is siraj i want to know cognos queriy language

2243

What are the types of studio?

1122

How can create users and permissions in cognos?

936

how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?

1121

can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2216

Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?

2069

--------------Diff b/w ODS and OLAP?

3174

What are the roles defined by cognos platform?

1104