K
kh
I am developing an ASP.Net app which hits an AS400 table. I have the
following SQL statement in ASP but get a token error when I execute:
Select TOP 1 prodmo, prodyr FROM AS400Table WHERE prprty = '11'
AND wlprdc = 'Product'
ORDER BY prodyr DESC, prodmo DESC
What is the SELECT TOP sql equivalent for AS400?
*-----------------------*
Posted at:
www.GroupSrv.com
*-----------------------*
following SQL statement in ASP but get a token error when I execute:
Select TOP 1 prodmo, prodyr FROM AS400Table WHERE prprty = '11'
AND wlprdc = 'Product'
ORDER BY prodyr DESC, prodmo DESC
What is the SELECT TOP sql equivalent for AS400?
*-----------------------*
Posted at:
www.GroupSrv.com
*-----------------------*