Is there any substitue for oracle's rownum command (which returns record serial number) in SQL. I'm querying data ,backend Access, with VB and could'nt find any suitable sql statement which does that.
Is it possibe to number rows(serial wise) generated using data report. I don't have any SNO field in my Access Table.
Neither i want to use any.
Eg:
1. field1 field2 field3 ...
2. field1 field2 field3 ...
3. ................
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.