Question: what is the difference between unique and distinct keyword in dbms?
Answer: The main difference between Unique and Distinct in SQL is that Unique helps to ensure that all the values in a column are different while Distinct helps to remove all the duplicate records when retrieving the records from a table. ... Unique and Distinct are two of them which allows writing SQL queries.