函数返回指定的列中第一个记录的值。
SELECT TOP 1 column_name FROM table_name
ORDER BY column_name ASC;
ORDER BY column_name ASC;
实例
SELECT TOP 1 name FROM Websites
ORDER BY id ASC;
ORDER BY id ASC;
函数返回指定的列中最后一个记录的值。
SELECT TOP 1 column_name FROM table_name
ORDER BY column_name DESC;
ORDER BY column_name DESC;
实例
SELECT TOP 1 name FROM Websites
ORDER BY id DESC;
ORDER BY id DESC;