Interested to Buy Any Domain ? << Click Here >> for more details...
write s sql query following table some duplicate present i
want unique one column duplicate another column display?
name id
a 1
a 1
b 2
b 2
c 3
i want the required output like
unique duplicate
name id name id
a 1 a 1
b 2 b 2
c 3
- 4 Answers
- 8890 Views
- Bank Of America, I also Faced
- E-Mail Answers
Answer Posted / anto
unique
select distinct name,id from table
duplicate
select name,id from table
group by name,id
having count(name||id) > 1
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Slowly changing dimensions, types and where will you use them
can anyone explain me about retail domain project in informatica?
What is depict expression change?
Explain sessions and how many types of sessions are there?
How to start a workflow using pmcmd command?
Explain the shared cache and re-cache?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Write the prerequisite tasks to achieve the session partition?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is informatica powercenter repository?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
How to load last n records of file into target table - informatica
State the differences between sql override and lookup override?
Explain pmcmd command usage in informatica
What is InformaticaPowerCenter?
