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
- 20846 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
How to RD using transformer?
What are the job parameters?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
How to convert RGB Value to Hexadecimal values in datastage?
If you want to use the same piece of code in different jobs, how will you achieve it?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
root tree will find which is server job and which is parallel job?
What is oci?
What are the types of containers in datastage?
What are the areas of application?
What are the important features of datastage?
What a datastage macro?
How to manage date conversion in Datastage?
