Interested to Buy Any Domain ? << Click Here >> for more details...
write a query for how to eliminate the duplicate rows
without using distinct?
- 6 Answers
- 11936 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / mani
DELETE FROM EMP WHERE ROWID NOT IN (SELECT MAX(ROWID)FROM
EMP)GROUP BY EMPNO;
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
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
What are the designer tools for creating transformations?
Can we create a Integration service without a Repository service and vice versa?
Explain the different kinds of facts.
What is sorter transformation?
Briefly explain the aggregator transformation?
What is dynamic cache?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How do you convert single row from source into three rows into target?
How to implement security measures using repository manager?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What are the mapping parameters and mapping variables?
