select distinct client_number from <table

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

Question Posted / aswini

1 Answers
4341 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / aswini

select distinct client_number from <table_name>;

Is This Answer Correct ?

4 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why do we use coalesce function in oracle?

1096

Explain oracle 12c new features for developers?

1023

What is an oracle user account?

964

What is oracle and what are its different editions?

1054

How to define a cusotmer as a supplier in ORACLE R12

2212

Is oracle a relational database?

899

What is proxy method?

959

How to synchronize 2 schema's objects?

2153

Explain what are synonyms used for?

1024

How to unlock the sample user account in oracle?

994

Explain the features of oracle?

1021

What is an oracle?

994

what is the difference between restoring and recovering?

998

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

2170

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2481