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 informix sql?

752


Does sql require a server?

747


What is trigger and types?

791


what is log shipping? : Sql dba

886


How does sql profiler work?

790


What are aggregate and scalar functions?

786


Is there any restriction on the use of union in embedded sql?

915


What is a record in a database?

819


What does a pl/sql package consist of?

755


What is sql character function?

754


How to select 10 records from a table?

909


Why is a trigger used?

738


What is sharding in sql?

768


How do I count rows in sql?

781


What is the purpose of cursors in pl/sql?

848