Interested to Buy Any Domain ? << Click Here >> for more details...
I am having a table with columns
ID NAME
1 x and the requirement is to get the o/p like this
1 y ID Count(*)
1 z 1 3
2 a 2 2
2 b
3 c
so write a sql query to get the id n how many times its
count of repetition n there u shouldn't get the distinct(i.e
id-3)
Reply as early as possible
- 3 Answers
- 6133 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / akash khanwalkar
This one is without using HAVING clause:
SELECT TEMP.ID, TEMP.ID_COUNT FROM
(
SELECT ID AS ID, COUNT(ID) AS ID_COUNT FROM TEMP_ID_TABLE
GROUP BY ID
) TEMP
WHERE TEMP.ID_COUNT > 1;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is mapping debugger?
What is transformation?
What are the differences between a connected lookup and unconnected lookup?
differences between service based and product based?
Plz can any one say me how to get the informatica certification materials and dumps
How can you increase the performance in joiner transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Can we create a Integration service without a Repository service and vice versa?
How to extract the informatica rejected data?
Enterprise data warehouse your projects phase by phase explain?
Explain the features of connected and unconnected lookup.
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Explian the Process of deployment groups in informatica
How will the document be delivered to me?
