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
- 8070 Views
- I also Faced
- E-Mail Answers
Answer Posted / haribabu
select ename,empno,count(*) from emp group by empno having count(*)>1;
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Performance tuning( what you did in performance tuning)
differences between service based and product based?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Can we change Dynamic to Static or Persistent cache? If so what happens?
Explain pushdown optimization and types in informatica
In which transformation you cannot drag ports into it?
server hot-ws270 is connect to Repository B. What does it mean?
What is primary and backup node?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is a filter transformation?
How to create the source and target database connections in server manager?
Explain the difference between a data warehouse and a data mart?
Can you use flat files in Mapplets.
What is domain and gateway node?
