Difference between SELECT * FROM TABLE vs SELECT DISTINCT * FROM TABLE

Question

Jignesh Kumar · Answer

Hello, SELECT * FROM TABLE This query will return all records from given table. SELECT DISTINCT * FROM TABLE this query will will eliminate duplicate record. It mean return only unique records from given table.

Amit Mohanty · Answer

DISTINCT means that there will be no duplicate values in the resultset. So SELECT DISTINCT * FROM TABLE means select all columns and skip any rows where the values in all columns match to other row all columns value". SELECT * FROM TABLE means it will show all rows present in the table.

Aravind Govindaraj · Answer

Consider you have 2 records in your table, which does not have any index, primary and unique keys. Both row has same values .... While using select query you get 2 records however in distinct you get single row. Because it validate all column values if same then it will yield only one row....

Abhishek Yadav · Answer

select * from table shows all the rows but select dustinct * shows only unique values dublicate records are not shown

Vishal Joshi · Answer

DISTINCT Keyword in select statement means no duplicate records in the result. if you just fire SELECT * FROM TABLE NAME it will return all records of the table. and if you add DISTINCT then it will return rows except for duplicates. Please check the below example to get more clear. SELECT * FROM Employees EmployeeId FullName EmpCode 3 Emp1 001 4 emp2 002 5 Emp1 001 6 Emp1 001 6 Emp1 001 SELECT DISTINCT * FROM Employees EmployeeId FullName EmpCode 3 Emp1 001 4 emp2 002 5 Emp1 001 6 Emp1 001 You can use DISTINCT on single column also as below: SELECT DISTINCT(EMPCODE) FROM EMPLOYEES EmpCode 001 002

Uday Dodiya · Answer

Hello, Jaya Please refer In the following, I already explain this. https://stackoverflow.com/questions/73644411/difference-between-select-from-table-vs-select-distinct-from-table/73644633#73644633

Brahma Prakash Shukla · Answer

Select * from table will return all the data of the table i.e all the rows which table have. Select distinct * from table will return the unique values only.It will not return duplicated record. DISTINCT means that there will be no duplicate rows in the resultset, duplicate meaning all columns have the same value in both rows. So yes, DISTINCT * means "select all columns and skip any rows where the values in all columns match some already included row".

Amit Kumar · Answer

Hi, Firstly : SELECT DISTINCT * FROM TABLE in this query DISTINCT always used with . then SELECT * FROM TABLE : Returns all records from the specific table but SELECT DISTINCT (column name) * FROM TABLE : It removes the duplicate values in the specific column from the table and then return the result set.

Vishal Yelve · Answer

In SQL Query when we use "*" the query does not eliminate duplicate rows. If the DISTINCT keyword is specified, a query eliminates rows that are duplicates according to the columns in the SELECT clause