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 reset a sequence in oracle?

831

What is materialized view in Oracle?

832

Explain a private synonyms?

820

what is the scenario where you take the database to NoArchivelog mode?

2063

Explain about achiever in sql?

796

Explain the use of rows option in exp command.

812

How to create a temporary table in oracle?

935

What is the recommended interval at which to run statspack snapshots, and why?

2658

What do you understand by a database object?

788

Is insert autocommit in oracle?

789

What is an oracle table?

746

What is transaction control statement and how many types of transaction control statement in Oracle?

811

What is a cognitive schema?

691

Can the query output be sorted by multiple columns in oracle?

749

What is the difference between a hot backup and a cold backup in oracle?

768