by
3,709 13
0
4
293
1
Top 10% !
Popular
Specified
OpenSource
Popularity: 1153343rd place
No tags for this snippet yet.
Languagesql
LicenseMIT_X11

Getting Min or Max value without aggregates

SQL Server Transact SQL
Copy Embed Code
<iframe id="embedFrame" style="width:600px; height:300px;"
src="https://www.snip2code.com/Embed/856690/Getting-Min-or-Max-value-without-aggrega?startLine=0"></iframe>
Click on the embed code to copy it into your clipboard Width Height
Leave empty to retrieve all the content Start End
// Enter here the actual content of the snippet. // Select max value without using MAX() //Version 1 SELECT * FROM SO.dbo.MaxNoAgg mna1 LEFT JOIN SO.dbo.MaxNoAgg mna2 ON (mna2.salary > mna1.salary) WHERE mna2.mna_id IS NULL; //version 2 SELECT age FROM Owner o1 WHERE NOT EXISTS (SELECT 1 FROM Owner o2 WHERE o2.age > o1.age)
If you want to be updated about similar snippets, Sign in and follow our Channels

blog comments powered by Disqus