Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select Max -vs- Select Top
Message
From
01/05/2001 17:34:52
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00502179
Message ID:
00502275
Views:
21
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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform