If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

how to get 2nd highest salary in oracle

Started by inu, 04 May 2014 08:54:50 AM

Previous topic - Next topic
Print
Go Down Pages1
User actions

inu

04 May 2014 08:54:50 AM Last Edit: 16 Jul 2014 08:25:47 AM by MFGF
Hi
Please tell me in oracle db , what sql i need to write to get the 2nd  highest sal in emp table


Thanks
Inam

MFGF

#1
05 May 2014 09:45:21 AM
Quote from: inamulhaque on 04 May 2014 08:54:50 AM
Hi
Please tell me in oracle db , what sql i need to write to get the 2nd  highest sal in emp table


Thanks
Inam

Hi Inam,

Why do this in Oracle SQL rather than in your Cognos model?

MF.


Sent from my iPad using Tapatalk HD
Meep!
Print
Go Up Pages1
User actions
BSP Software Documentation
MetaManager Documentation and Knowledgebase
Version Control Documentation and Knowledgebase
BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel Micro Strategies Inc
Security Migration IBM Cognos
Integrated Management Suite