Differences between UNIQUE and DISTINCT in select statements

Answer Posted / anilkumar kambala

UNIQUE:
UNIQUE CAN TAKE UNIQUE DATA
USING DISTINCT CLAUSE SORTING THE DATA

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a constraint? Tell me about its various levels.

872


Is it possible to include an insert statement on the same table to which the trigger is assigned?

759


How to write pl sql program in mysql command prompt?

750


Why schema is used in sql?

754


Is sqlite good enough for production?

762


What view means?

757


how do you login to mysql using unix shell? : Sql dba

768


how to calculate expressions with sql statements? : Sql dba

744


what are aggregate and scalar functions? : Sql dba

771


What is the difference between microsoft access and sql?

761


What are crud methods?

766


What does fetching a cursor do?

829


What are the parts of a basic sql query?

750


Is oracle and sql same?

767


Which join is like an inner join?

747