JavaSlave
asked on
How to create a counter (Row number) in UDF ?
I want to create a counter in UDF. The counter I mean :
"SELECT counter(), field1 FROM table1"..
The result is :
1 , data1
2 , data2
3 , data3
4 , data4
5 , data5
Please give me brief steps info about it. Thank you so much!! :)
"SELECT counter(), field1 FROM table1"..
The result is :
1 , data1
2 , data2
3 , data3
4 , data4
5 , data5
Please give me brief steps info about it. Thank you so much!! :)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
JavaSlave:
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.
ASKER
But I hope to do the effect in UDF. Without modify or write complicated SQL statement. Please give me some related examples. Thank.