Interested to Buy Any Domain ? << Click Here >> for more details...
write a sql query following table?
col1 col2
1 2
1 2
1 2
3 4
3 4
5 6
i want the output like
unique duplicate
col1 col2 col1 col2
1 2 1 2
3 4 1 2
5 6
- 1 Answers
- 3391 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer / vaibhav jogale
We can achieve this using With clause
insert into TEST_UNIQ (col1,col2)
with Ct_Test as (
select col1,col2,row_number () over (partition by col1,col2 order by col1,col2)Rw_no
from test123)
select col1,col2 from Ct_Test where rw_no=1
/
insert into TEST_DUp (col1,col2)
with Ct_Test as (
select col1,col2,row_number () over (partition by col1,col2 order by col1,col2)Rw_no
from test123)
select col1,col2 from Ct_Test where rw_no>1
/
| Is This Answer Correct ? | 1 Yes | 0 No |
How the informatica server sorts the string values in Rank transformation?
Can you generate reports in Informatcia?
When the informatica server marks that a batch is failed?
Which is the t/r that builts only single cache memory?
h0w many versions have been developed of onformatica so far?
What is the different lookup cache(s)?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is the difference between Bulk Load and Normal Load
When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?
How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?
Teradata 
