select distinct client_number from <table

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

Question Posted / aswini

Answer Posted / aswini

select distinct client_number from <table_name>;

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the simplest tool to run commands on oracle servers?

1003

How to initialize variables with default values?

1231

Please explain compound trigger in oracle?

1053

How to define an oracle sub procedure?

1136

What is a system tablespace?

1065

State any two functions of oracle?

1042

How to write a left outer join with the where clause in oracle?

1082

Explain what are clusters?

1104

How to convert a string to a date in oracle database?

1045

Why we use bulk collect in oracle?

1034

Who developed oracle & when?

997

Explain the difference between sap and oracle?

1029

Can you have more than one content canvas view attached with a window ?

2328

What is the oracle implicit cursor?

1053

How to view the tablespaces in the current database?

971