Unique element in sql

DISTINCT
- select distinct * from employees; ==> retrieves any row if it has at
least a single unique column.
- select distinct first_name from employees; ==> retrieves unique names
from table. (removes duplicates)
- select distinct count(*) from employees; retrieve number of unique rows
if any row has at least a single unique data.

Similar codes

0 vote110 views1 answer
Check if string is a number sql
SQL
13 votes109 views2 answers
Oracle select into and inner join
SQL
11 votes112 views1 answer
How to get ddl for materialized view
SQL
1 vote105 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
20 votes113 views1 answer
Sql change column types
SQL
0 vote120 views1 answer
Sqlalchemy get schema from database
SQL
0 vote105 views1 answer
Oracle list index on table
SQL
0 vote115 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
3 votes112 views1 answer
Fk in insert mysql
SQL
0 vote108 views1 answer
Date 3 months from today sql
SQL