首页SELECT DISTINCT

SELECT DISTINCT

时间: 2024-02-10 14:59:55 浏览: 49

消除重复行续-SELECT语句查询记录

消除重复行（续） USE northwind SELECT DISTINCT country FROM suppliers ORDER BY country GO 示例 1.3.2 消除重复行 country Australia Brazil Canada Denmark Finland France Germany Italy Japan Netherlands Norway Singapore Spain Sweden UK USA 参考：示例查询表 suppliers 中所有的行，但每个国家名字只显示一次。

`SELECT DISTINCT` is a clause used in SQL queries to retrieve only unique values from a table or a result set. It filters out duplicate records and returns only one instance of each unique record. For example, if you have a table of sales data and you want to retrieve a list of distinct product names, you can use `SELECT DISTINCT product_name FROM sales_data`.

阅读全文