3. Display all the client numbers in the ORDER table. Remove duplicates.

3. Display all the client numbers in the ORDER table. Remove
duplicates.

Question Posted / deepakgunji

3. Display all the client numbers in the ORDER table. Remove duplicates...

Answer / aswini

select distinct client_number from <table_name>;

Is This Answer Correct ?

4 Yes

0 No

More Oracle General Interview Questions

what is the use of ondelete cascade?

In oracle there is column command, how will you explain that?

What is bulk load in oracle?

Explain the relationship among Database, Tablespace and Data file?

How to convert dates to characters in oracle?

Can we write insert statement in function in oracle?

What is difference between SQL and SQL*PLUS?

What is oracle instant client?

how to genarate random numbers in oracle for particular row?

How to retrieve data from an explicit cursor?

How to execute the package in oracle?

How to do clean up if create database failed?

For more Oracle General Interview Questions Click Here