Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi can any one help me..
This is my table data.
Type | Id | Date | Amount |
Rec | 1 | 04-01-15 | 5000 |
Rec | 2 | 05-01-15 | 6000 |
Pay | 1 | 06-01-15 | 2000 |
Rec | 3 | 07-01-15 | 1000 |
Pay | 2 | 08-01-15 | 8000 |
Output:
Rec ID | Pay ID | Amount |
1 | 1 | 2000 |
1 | 2 | 3000 |
2 | 2 | 5000 |
is it possible?
Are you all working in same company or this is an interview question?
Manish Kachhia wrote:
Are you all working in same company or this is an interview question?
Hopefully the company interviewing will monitor the community to see if the answers are all the same!
It is an interview question.
Ok.. .Can you give an explanation on how you want to get the output?
I need to know the explanation not by words but by expression or some +/- calculation.