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

How do I recompile a procedure in oracle?

525

How to bring a tablespace offline?

535

How to invoke the original export import utilities?

503

How to put more than 1000 values into an oracle in clause?

579

What is a procedure in oracle?

614

Explain joins in oracle?

557

Differentiate between function and procedure in oracle.

557

What happens if the update subquery returns multiple rows?

599

What are the types of partitions in oracle?

534

What are the different types of record groups in oracle? Explain each of them

596

candidate key is subset of super key but not vice-verse explain

1572

Explain the difference between a procedure and a function?

552

Use of an integrity constraint is better to validate data. Explain

541

What is a table in oracle?

535

What is a table index in oracle?

626