 |
Home
SQL
PL/SQL
MySQL
MongoDB
PostgreSQL
SQL Server
Oracle
Cassandra
SQLite
DBMS
Python
Java
Aptitude
Interview Q
SQL SELECT UNIQUEActually, there is no difference between DISTINCT and UNIQUE. SELECT UNIQUE is an old syntax which was used in oracle description but later ANSI standard defines DISTINCT as the official keyword. After that oracle also added DISTINCT but did not withdraw the service of UNIQUE keyword for the sake of backward compatibility. In simple words, we can say that SELECT UNIQUE statement is used to retrieve a unique or distinct element from the table. Let's see the syntax of select unique statement. SQL SELECT DISTINCT statement can also be used for the same cause.
Next TopicSQL SELECT DISTINCT
|
For Videos Join Our Youtube Channel: Join Now
Feedback
- Send your Feedback to [email protected]
Help Others, Please Share
Javatpoint Services
JavaTpoint offers too many high quality services. Mail us on h[email protected], to get more information about given services.
- Website Designing
- Website Development
- Java Development
- PHP Development
- WordPress
- Graphic Designing
- Logo
- Digital Marketing
- On Page and Off Page SEO
- PPC
- Content Development
- Corporate Training
- Classroom and Online Training
- Data Entry
Training For College Campus
JavaTpoint offers college campus training on Core Java, Advance Java, .Net, Android, Hadoop, PHP, Web Technology and Python. Please mail your requirement at [email protected].
Duration: 1 week to 2 week
