Oracle Database11g tutorials 8 || SQL DISTINCT with multiple columns |SQL Distinct with Two columns

This SQL tutorial and Oracle database 11g tutorial for beginners will show how to use SQL DISTINCT keyword with SQL Select clause.
This Video is in the continuation of previous video on SQL distinct with one column. In this video we will see How to use SQL distinct with multiple columns and SQL distinct with two columns
Tool used in this tutorial is SQL developer.
This tutorial series is part of SQL expert exam certification training. If you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training.

Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage

Contacts
Email

Twitter

Instagram

Facebook.

Linkedin.

Thanks for linking, commenting, sharing and watching more of our videos

This is Manish

From The Code makers

[abhinavgaur]

Hi Manish :) thanks a lot for these very productive videos koz these videos are helping those who are eagerly want to learn oracle but because of some circumstances they are not able to and i am one of those so thanks a ton once again and keep teaching us :) God bless you

[brightlight_MMA]

Thanks bro
I am learner and I like your explanation

[Judy]

You did a great job for us, thank you.

[dhananjayanchirag]

hi sir... i am preparing for become a certificated oracle dba.. so, this videos... which is very useful to me

[ravindranrajaMBA]

Hello Danish Thanknyou for you spending your valuable time. I have doubt the table name 'example' which you used to explain distinct is it a default table like employees or have you created it to explain to us.

[andreastewart]

Thank you,   I enjoyed your video.    I'm trying to get my OCA cert,    I've downloaded oracle express,   but the sample schema is not there,    did I download the wrong URL,    can you help me or suggest a URL so I can practice the examples in the book?

[faranakso]

Thank you so much Manish..these are so helpful..perfect ..can you please tell me how I can insert a data inside each table? and also how can I unlock the HR as I have already installed Oracle but in the binning did'nt unblock it.

[akashrathor]

the final result a unique row but if i want distinct values from each column ??? like in first column there in one value in second column there are three values and in third there is four values . how to display them in single query

[sethupathi]

Hi sir i am Sethupathi sir please suggest me any oracle sql and plsql books

[sethupathi]

Hi sir please suggest me any orcpe sql and plsql books

[withme]

hi manish, can u help me in installation of Oracle 11g on linux centos

[Nimitz_oceo]

Hi Manish, Thanks a lot for all your wonderful work. I am having some difficulties while trying to run the query and getting the following error:

" ORA-00942: table or view does not exist
00942. - "table or view does not exist"
*Cause:
*Action:
Error at Line: 9 Column: 15"
am i doing something wrong?

[ZackOugh]

can I distinct on one cumulu only (first_name) to force it to show only steven + middle name + lastname.

[abhiw]

hello manish 
i don't understand table.
if i type and try run at that tym it shows something error.
can you please help me how to create that table.

[Cevidzz]

You created a table but how you added data into it.

[pranjalchoudharygoogle]

hey, i wanna take up the "Oracle Database SQL Expert" exam....The exam price currently is Rs. does this package mean only the exam itself Or some training

Do reply, thnx....

[chakri]

hi sir, i cant able to run the table please help me ASAP ...iam getting the following error:-

ORA-00904: "FIRST_NAME": invalid identifier
00904. - "%s: invalid identifier"
*Cause:
*Action:
Error at Line: 10 Column: 8