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
Recent Posts
Most Viewed Posts
- Get the First and Last Word from a String or Sentence in SQL (245)
- How to use Map Mode for Vertical Scroll Mode in Visual Studio (195)
- How to make some specific word(s) Bold or Underline in ReportViewer (187)
- How to solve “Response.Redirect cannot be called in a Page callback” for DevExpress Components (184)
- Confirm before process with ASPxButton in Devexpress (173)