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
----- Original Message -----
Sent: Sunday, June 05, 2005 3:52 PM
Subject: [Microsofts_C_Sharp] QUERIES IN .NET

SIR,
  HELLO IAM NEW TO THIS GROUP AND I HAVE FOLWING QUES.
1) IF YOU HAVE A DATABASE OF 1 MILLION RECORDS AND
YOU WANT TO VIEW IN A SINGLE DATAGRID AT A TIME HOW IT
IS POSSIBLE.

2)CAN ANY ONE SUGGEST REGULAR _expression_ FOR EMAIL

3)HOW REQUIRED FIELD VALIDATOR CAN BE USED FOR RADIO
BUTTONS.

4)suggest a sql query for finding nth highest


           
__________________________________
Discover Yahoo!
Find restaurants, movies, travel and more fun for the weekend. Check it out!
http://discover.yahoo.com/weekend.html



Yahoo! Groups Links

Reply via email to