MIN returns the smallest value in a column of all selected records by the query of any char, number, or datetime datatype. : Min « Aggregate Functions « SQL Server / T-SQL Tutorial






3>
4>
5> CREATE TABLE sales(
6>    stor_id        char(4)           NOT NULL,
7>    ord_num        varchar(20)       NOT NULL,
8>    ord_date       datetime          NOT NULL,
9>    qty            smallint          NOT NULL,
10>    payterms       varchar(12)       NOT NULL,
11>    title_id       varchar(80)
12> )
13> GO
1> insert sales values('1', 'QA7442.3', '09/13/94', 75, 'ON Billing','1')
2> insert sales values('2', 'D4482',    '09/14/94', 10, 'Net 60',    '1')
3> insert sales values('3', 'N914008',  '09/14/94', 20, 'Net 30',    '2')
4> insert sales values('4', 'N914014',  '09/14/94', 25, 'Net 30',    '3')
5> insert sales values('5', '423LL922', '09/14/94', 15, 'ON Billing','3')
6> insert sales values('6', '423LL930', '09/14/94', 10, 'ON Billing','2')
7> GO

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)
1>
2>
3> select MIN(ord_date) from sales;
4> GO

-----------------------
1994-09-13 00:00:00.000

(1 rows affected)
1>
2> drop table sales;
3>
4> GO








9.5.Min
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()