SELECT m1.Column1, m1.Column2, m1.Column3, r.MaxTime FROM ( SELECT Column1, MAX(TimeColumn) as MaxTime FROM MyTable GROUP BY Column1 ) r INNER JOIN MyTable m1 ON m1.Column1= r.Column1AND m1.TimeColumn = r.MaxTime
Tag: max
Most Viewed Posts
- Get the User Name and Domain Name from an Email Address in SQL (848)
- Get the First and Last Word from a String or Sentence in SQL (756)
- How to select distinct rows in a datatable in C# (709)
- How to add default value for Entity Framework migrations for DateTime and Bool (585)
- Add Constraint to SQL Table to ensure email contains @ (521)