Need Help on query [message #637080] |
Sun, 10 May 2015 03:58 |
|
samyms
Messages: 18 Registered: May 2015 Location: Chennai
|
Junior Member |
|
|
please help me to write a query
input table;(yr,qtr not in order)
Yr qtr amt
2015 2 4300
2015 1 3000
2014 4 1270
2014 3 1250
2014 2 1100
2014 1 1400
output table:
Yr qtr amt preamt
2015 2 4300 3000
2015 1 3000 1270
2014 4 1270 1250
2014 3 1250 1100
2014 2 1100 1400
2014 1 1400
[Updated on: Sun, 10 May 2015 03:59] Report message to a moderator
|
|
|
|
|
Re: Need Help on query [message #637084 is a reply to message #637083] |
Sun, 10 May 2015 04:15 |
John Watson
Messages: 8922 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
I have no idea if your code is correct, because you have not shown what it has produced, and I certainly can't run it. Furthermore, you have ignored all my suggestions and clearly you have not read the docs to which I directed you.
Not a very good way to introduce yourself to a professional forum. Do you want to try again?
|
|
|
|
|
|
|
|
|