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
- 8726 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
differences between service based and product based?
what is the size of your data warehousing?
Explain in detail scd type 2 through mapping.
What is target load order?
How can we create index after completion of load process?
How can you define user defied event?
tell me the rules and responsblites in our project(my project is development)
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is the difference between Active and Passive transformation?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Slowly changing dimensions, types and where will you use them
Explain incremental aggregation in informatica
What can we do to improve the performance of informatica aggregator transformation?
What is xml source qualifier transformation in informatica?
can you please explain me pre session and post session options?
