Interested to Buy Any Domain ? << Click Here >> for more details...
In a table there are 1 million records there in which 3
records are duplicate how will you find out those 3 records?
- 6 Answers
- 9504 Views
- I also Faced
- E-Mail Answers
Answer Posted / santosh kumar sarangi
select * from emp where empno in (select empno from emp
group by sal having count(*)>1)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
In how many ways we can create ports?
What is InformaticaPowerCenter?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How many input parameters can exist in an unconnected lookup?
What is the maplet?
How to start a workflow using pmcmd command?
what is size of u r database?
What is powercenter on grid?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is a joiner transformation and why it is an active one?
Could you explain what is enterprise data warehouse?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What are the types of schemas we have in data warehouse and what are the difference between them?
what is Active lock explain
Differentiate between Load Manager and DTM?
