Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 21580 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
What is a ds designer?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
How to manage date conversion in Datastage?
Explain entity, attribute and relationship in datastage?
What is the method of removing duplicates, without the remove duplicate stage?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What is process model?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What is the flow of loading data into fact & dimensional tables?
what is the difference between == and eq in UNIX shell scripting?
What are the job parameters?
What is aggtorec restructure operator?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
How will you move hashed file from one location to another location?
Enlist various types of routines in datastage.
