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 are the attributes of cursor?

1054

Describe an oracle table?

1049

What is the data type of dual table?

993

What is a database schema in oracle?

1110

How can windows applications connect to oracle servers?

1057

How to insert a record into a table?

1068

Can we create database in oracle using command line ?

1085

what is the difference between restoring and recovering?

1011

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

1155

What is key preserved table?

1021

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1911

What is a snapshot log?

1003

What is Trigger in Oracle?

1170

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1349

How to sort the query output in oracle?

1028