Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: inu on 04 May 2014 08:54:50 AM

Title: how to get 2nd highest salary in oracle
Post by: inu 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
Title: how to get 2nd highest salary in oracle
Post by: MFGF on 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
Text only | Text with Images