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

Describe an oracle table?

987

Explain the use of show option in imp command.

1045

How to pass parameters to procedures in oracle?

993

Explain the use of ignore option in imp command.

975

What is a user account in oracle?

1065

How do you bind variables in oracle?

928

What are the execution control statements?

1015

Can multiple cursors being opened at the same time?

1016

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

955

What is the Tune Query

2232

How to define an anonymous procedure with variables?

1060

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2772

How to view the tablespaces in the current database?

927

How to write a query with an inner join in oracle?

973

How to join two tables in a single query using oracle?

929