lkpcustomer.blogg.se

One thing to note is that there should be at least one table name after from clause. Tables: We provide the table names from which we want the records.Expressions: In this, we provide the column names or calculations that we want.Select DISTINCT(expressions) from tables Below is the syntax for a distinct keyword. Let’s now look at the various parameters present in a distinct keyword. Parameters used for Distinct Keyword in SQL If we remove a distinct keyword, it will retrieve four values instead of three. On running, it will return the unique city names, which are Mumbai, Delhi, Lucknow. In our example above, we can see that the city is the column that has repetitive values, so we will put the city in place of column_name and employee in place of table_name. Select DISTINCT(column_name) from table_name Let’s have an employee table with three columns: empId, empname, and city, as shown below: Let’s look at the distinct keyword syntax with an example: Hadoop, Data Science, Statistics & others