Min « Aggregate Functions « SQL Server / T-SQL Tutorial

9.5.1.MIN returns the smallest value in a column of all selected records by the query of any char, number, or datetime datatype.
9.5.2.A summary query that uses the MIN and MAX functions
9.5.3.Query Using MIN() and MAX() on Same Column
9.5.4.id = (SELECT MIN(id) FROM employee)
9.5.5.Finding the Earliest Date Using MIN()
9.5.6.Finding the First Order for Each Customer Using MIN()