how to retrieve unique records in oracle


How to retrieve unique records in oracle

Using distinct keyword we can retrieve unique record from table in oracle.We have to pass column name along with distinct keyword.

Syntax

>select distinct column_name from table_name;

Example

>select distinct name from student;






Full-stack web and mobile app development company Contact Us : Skype: indore.webcoder Email: info@w3sparks.com Sales: +91 8085506229