-- select the unique ages from the Customers tableSELECTDISTINCTageFROMCustomers; Run Code Here, the SQL command selects only the unique values of age from theCustomerstable. Syntax of SQL SELECT DISTINCT SELECT
Syntax: SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr ...] [FROM table_references [PARTITION partition_list] [WHERE where_co...
Syntax:SELECT[ALL | DISTINCT | DISTINCTROW][HIGH_PRIORITY][STRAIGHT_JOIN][SQL_SMALL_RESULT][SQL_BIG_RESULT][SQL_BUFFER_RESULT]SQL_NO_CACHE[SQL_CALC_FOUND_ROWS]select_expr[, select_expr ...][FROM table_references [PARTITION partition_list][WHERE where_condition][GROUP BY {col_name | expr ...
SQL SELECT SQL SELECT DISTINCT SQL WHERE where clause SQL AND,OR AND NOT Operators SQL ORDER BY ASC:ascending/ DESC:descending SQL INSERT INTO If you are adding values for all the columns of the table, you do not need to specify the column names in the SQL query....
syntaxsql 複製 SELECT [ ALL | DISTINCT ] [ TOP ( expression ) [ PERCENT ] [ WITH TIES ] ] <select_list> <select_list> ::= { * | { table_name | view_name | table_alias }.* | { [ { table_name | view_name | table_alias }. ] { column_name | $IDENTITY | $ROWGUID }...
Syntax Querying data [ WITH [ RECURSIVE ] with_query [, ...] ] SELECT [/*+ plan_hint */] [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ] { * | {expression [ [ AS ] output_name ]} [, ...] } [ FROM from_item [, ...] ] [ WHERE condition ] [ GROUP BY grou...
SELECTDISTINCTCountryFROMCustomers; Try it Yourself » Inside a table, a column often contains many duplicate values; and sometimes you only want to list the different (distinct) values. Syntax SELECTDISTINCTcolumn1,column2, ... FROMtable_name; ...
sql SELECT last_name "Name", salary*12 "Annual Salary" FROM employees; 去除重复行 默认情况下,查询会返回全部行,包括重复行。 SELECT department_id FROM employees;在SELECT语句中使用关键字DISTINCT去除重复行 SELECT DISTINCT department_id FROM employees;针对...
syntaxsql [WITH<common_table_expression>[ , ...n ] ]SELECT<select_criteria>[ ; ]<select_criteria>::=[TOP(top_expression) ] [ALL|DISTINCT] { * |column_name| expression } [ , ...n ] [FROM{table_source} [ , ...n ] ] [WHERE<search_condition>] [GROUPBY<group_by_clause>] [HA...
SELECT column_name(s)FROM table_name1 JOIN table_name2 ON table_name1.column_name=table_name2.column_name JOIN: 可以是 INNER JOIN、LEFT JOIN、RIGHT JOIN 或 FULL JOIN。 DISTINCT:用于返回唯一不同的值。 SELECT DISTINCT column_name(s)FROM table_name ...