Good morning,
following a select statement with a max() in the valuedate and name = Marianne and Amounttype = USD
valuedate |name |Exec_date |Amout
-----------------------------------------------------
2006-02-28 |Marianne |2006-03-27 14:41:07.167 |200
2006-02-28 |Marianne |2006-03-28 14:01:28.123 |121
2006-02-28 |Marianne |2006-03-29 10:05:32.843 |224
Now I would like to obtain the max of exec_date and have just one record.
valuedate |name |Exec_date |Amout
-----------------------------------------------------
2006-02-28 |Marianne |2006-03-29 10:05:32.843 |224
Do you think that I need to create a view with the first query and max the exec_date.
inarobis
following a select statement with a max() in the valuedate and name = Marianne and Amounttype = USD
valuedate |name |Exec_date |Amout
-----------------------------------------------------
2006-02-28 |Marianne |2006-03-27 14:41:07.167 |200
2006-02-28 |Marianne |2006-03-28 14:01:28.123 |121
2006-02-28 |Marianne |2006-03-29 10:05:32.843 |224
Now I would like to obtain the max of exec_date and have just one record.
valuedate |name |Exec_date |Amout
-----------------------------------------------------
2006-02-28 |Marianne |2006-03-29 10:05:32.843 |224
Do you think that I need to create a view with the first query and max the exec_date.
inarobis