General information
Category:
Coding, syntax & commands
Title:
Finding max(date) for a given date
Environment versions
Network:
Windows Server 2008 R2
Helo comunity
I will need to find the last movement (higher) for a given date ordering by numeric code ascending to find the price field.
Suppose that i will have 3 movement with the same date, ex. 31.07.2015 where the first numeric code is 9, the secund is 10 and finally
the last is 25.
I need to write
Select max(datalc) from mytable where max(datalc) ="31.07.2015" order by numeric code desc
How to compare max(datalc) with the given date?
Max(datalc)=ctod('31.07.2015'), is this correct?
Thanks for your Help.
Best regards,
Luis
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only