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?
- 11 Answers
- 17891 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / sudheer
the below query is to get only duplicate records
i.e..,
10
10
20
20
select * from sno
where sno in (select sno from ex
group by sno
having count(sno)>1
)
and the above query is to get only
10
20
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
sed,awk,head
explain about citrix scheduling tool in datastage
What is the roundrobin collector?
What are some prerequisites for datastage?
in oracle target stage when we use load option and when we use upsert option?
how to write server Routine coding?
How we can covert server job to a parallel job?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
How to read multiple files using a single datastage job if files have the same metadata?
Differentiate between hash file and sequential file?
Differentiate between datastage and datastage tx?
How to implement complex jobs in data stage?
What are the components of ascential data stage?
What is datastage engine?
What are the functionalities of link partitioner and link collector?
