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

How to connect to a remote server?

What is an oracle database?

What is a named program unit?

What is oracle used for?

Give the advantages and disadvantages of clusters.

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

Explain a synonym?

How can we create the complete backup of data in the oracle.

What are the limitations oracle database 10g xe?

what is the difference between simple view and complex view?

What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?

What is the difference between implicit index and explicit index?

For more Oracle General Interview Questions Click Here