select RANK , D *from(select roumun RANK,E. *from E) D where RANKIN 1,2,5

i have a table
col1
10
20
30
40
10
20
50
my requirement is how to retrive only duplicates like
10
10
20
20
like this how it's possible in SQL?

Question Posted / mcssrinivas009

Answer Posted / mcssrinivas009

select RANK , D *from(select roumun RANK,E. *from E) D where
RANKIN 1,2,5,6;
using this query we getting from our requirement

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is the value of staging variable stored temporarily or permanently?

930

Describe routines in datastage? Enlist various types of routines.

954

sed,awk,head

1409

What is the difference between orabulk and bcp stages?

967

What steps should be taken to improve Datastage jobs?

1003

Can you explain engine tier in information server?

1062

What are stage variables and constants?

1096

What is a folder? Difference types of stages?

1102

How and where you used hash file?

1110

what is the use of surogate key in datastage

2249

What are the different kinds of views available in a datastage director?

972

What are the types of views in datastage director?

1720

What are the functionalities of link partitioner?

972

What are the different types of lookups in datastage?

1006

Define Merge?

1259