Even shorter
SELECT Max(DataInsertion)
FROM Titre
But, I think all these will be optimized and got the same. Look at the query plan for each.
>What are the differences between these 2 queries:
>
SELECT *
>FROM Titre
>WHERE DateInsertion = (
> SELECT MAX(DateInsertion)
> FROM Titre)
>
>AND
>
>
SELECT *
>FROM Titre
>WHERE DateInsertion = (
> SELECT TOP 1 DateInsertion
> FROM Titre
> ORDER BY DateInsertion DESC)
>
>I found that the second syntax can be a lot faster.
>
>Can I safely replace my SELECT MAX with SELECT TOP?