Simple Query to Grab Max Value for each ID

by

Something like this? Join your table with itself, and exclude the rows for which a higher signal was found.

select cur.id, cur.signal, cur.station, cur.ownerid
from yourtable cur
where not exists (
    select * 
    from yourtable high 
    where high.id = cur.id 
    and high.signal > cur.signal
)

This would list one row for each highest signal, so there might be multiple rows per id.

More Related Contents:

  1. Get top 1 row of each group
  2. Select top 10 records for each category
  3. Return row with the max value of one column per group [duplicate]
  4. Is there a Max function in SQL Server that takes two values like Math.Max in .NET?
  5. T-SQL: Selecting Column Based on MAX(Other Column)
  6. Selecting all corresponding fields using MAX and GROUP BY
  7. SQL server select distinct rows using most recent value only
  8. Select corresponding to row from the same table SQL Server
  9. Optimize GROUP BY query to retrieve latest row per user
  10. How to calculate age (in years) based on Date of Birth and getDate()
  11. CROSS JOIN vs INNER JOIN in SQL
  12. INNER JOIN vs LEFT JOIN performance in SQL Server
  13. Function vs. Stored Procedure in SQL Server
  14. How to get difference between two rows for a column field?
  15. SQL Server: Get table primary key using sql query [duplicate]
  16. How to determine the number of days in a month in SQL Server?
  17. Concatenate values based on ID
  18. Finding duplicate rows in SQL Server
  19. How can I combine multiple rows into a comma-delimited list in SQL Server 2005?
  20. Why and when a LEFT JOIN with condition in WHERE clause is not equivalent to the same LEFT JOIN in ON? [duplicate]
  21. how to declare global variable in SQL Server..?
  22. SQL : in clause in stored procedure:how to pass values
  23. Split values over multiple rows [duplicate]
  24. Must declare the scalar variable
  25. How to get the identity of an inserted row?
  26. Insert Update stored proc on SQL Server
  27. TSQL – How to use GO inside of a BEGIN .. END block?
  28. Finding a Top Level Parent in SQL
  29. Sql Server : How to use an aggregate function like MAX in a WHERE clause
  30. How to get the next number in a sequence

Leave a Comment