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

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

Question Posted / deepakgunji

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

Answer / aswini

select distinct client_number from <table_name>;

Is This Answer Correct ?

4 Yes

0 No

More Oracle General Interview Questions

What is Hash Cluster ?

Explain the use of show option in imp command.

How do I spool in oracle?

how to truncate date and get only time part 9:20:00

How to create a new tablespace in oracle?

Explain the use of online redo log files in oracle.

What are synonyms used for ?

What the is the diff between local index and global index. give some example.

what are the database links ?

Youre getting high busy buffer waits - how can you find whats causing it?

How to use like conditions in oracle?

What is the use of Redo Log Information ?

For more Oracle General Interview Questions Click Here