I want to select the last row in my query.
I've already tried the as set with 1 rows
but it only displays 1 data only regarding if I have may types
I have an Sales Order Type of A, B and C.
The OUPUT when I use the Order by desc is this:
And then when I added as set with 1 rows it will display like this:
What I need to display is like this:
I tried the Select Max() but I'm getting an error, here is the sample query that have error:
where tdsls400.odat >= tdsls400.odat.f and
tdsls400.odat <= tdsls400.odat.t
group by tdsls400.orno
PS: I'm using the Query Data and I'm not creating any session.
Thanks in advance,