Sql Server : How to use an aggregate function like MAX in a WHERE clause

by

As you’ve noticed, the WHERE clause doesn’t allow you to use aggregates in it. That’s what the HAVING clause is for.

HAVING t1.field3=MAX(t1.field3)

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. Get top 1 row of each group
  3. SQL update query using joins
  4. How to update two tables in one statement in SQL Server 2005?
  5. Referring to a Column Alias in a WHERE Clause
  6. SQL query to select dates between two dates
  7. Convert Month Number to Month Name Function in SQL
  8. Create a date from day month and year with T-SQL
  9. SET versus SELECT when assigning variables?
  10. Selecting COUNT(*) with DISTINCT
  11. Generate a resultset of incrementing dates in TSQL
  12. Getting result of dynamic SQL into a variable for sql-server
  13. How to get difference between two rows for a column field?
  14. Better techniques for trimming leading zeros in SQL Server?
  15. SQL – Subtracting a depleting value from rows
  16. How to print VARCHAR(MAX) using Print Statement?
  17. What’s the best way to select the minimum value from several columns?
  18. Concatenate values based on ID
  19. Splitting delimited values in a SQL column into multiple rows
  20. SELECT FOR UPDATE with SQL Server
  21. varbinary to string on SQL Server
  22. SQL Server 2005 ROW_NUMBER() without ORDER BY
  23. Can an INNER JOIN offer better performance than EXISTS
  24. OPENXML with xmlns:dt
  25. SQL Server : SUM() of multiple rows including where clauses
  26. Cumulative Total in MS Sql server [duplicate]
  27. Use variable with TOP in select statement in SQL Server without making it dynamic [duplicate]
  28. Compare dates in T-SQL, ignoring the time part
  29. Memory effective way to read BLOB data in C#/SQL 2005
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment