| Last Value from Query? [message #7316] |
Wed, 04 June 2003 06:02  |
Andrew
Messages: 144
Registered: March 1999
|
Senior Member |
|
|
Hi,
I have the following query: -
SELECT CLOSING_DATE
FROM TB_CLOSINGS
WHERE CASHREG_ID = 1
AND TRUNC(CLOSING_DATE) < TO_DATE('03.06.2003','DD.MM.YYYY')
This returns 11 Rows.
What can I use to show the last CLOSING_DATE, so instead of all the rows I just get 1?
Regards,
Andrew
|
|
|
|
| Re: Last Value from Query? [message #7318 is a reply to message #7316] |
Wed, 04 June 2003 06:29  |
Art Metzer
Messages: 2480
Registered: December 2002
|
Senior Member |
|
|
SELECT tc.closing_date
FROM tb_closings tc
WHERE tc.cashreg_id = 1
AND TRUNC(tc.closing_date) < TO_DATE('03.06.2003'
, 'DD.MM.YYYY')
AND tc.closing_date = (SELECT MAX(tc2.closing_date)
FROM tb_closings tc2
WHERE tc2.cashreg_id = tc.cashreg_id
AND TRUNC(tc2.closing_date) < TO_DATE('03.06.2003'
, 'DD.MM.YYYY'))
A
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
