can any one help me

[#1]

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?

[MK_QSL]

first in frist out

How to find fifo order ?

Are you all working in same company or this is an interview question?

[ThornOfCrowns]

Manish Kachhia wrote:

first in frist out

How to find fifo order ?

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!

[#4]

It is an interview question.

[MK_QSL]

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.