|
Another way to find nth highest....
select distinct EMP_IN_EMPLY_CD_PK from
IMS_EMP_EMPLY_MSTR A
where 5 = (select count(EMP_IN_EMPLY_CD_PK) from (select distinct EMP_IN_EMPLY_CD_PK from IMS_EMP_EMPLY_MSTR) d where A.EMP_IN_EMPLY_CD_PK<=EMP_IN_EMPLY_CD_PK) With Regards, Pankaj Tyagi Software Engineer VCLABS
|
- [Microsofts_C_Sharp] QUERIES IN .NET hiren desai
- Re: [Microsofts_C_Sharp] QUERIES IN .NET Pankaj Tyagi
- Re: [Microsofts_C_Sharp] QUERIES IN .NET Pankaj Tyagi
- Re: [Microsofts_C_Sharp] QUERIES IN .NET Pankaj Tyagi
- [Microsofts_C_Sharp] How to use NUnit for ASP .Net ........ Pankaj Tyagi
