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 oracle latest version?

Does oracle partitioning improve performance?

sql query to get zero records from a table

Can a property clause itself be based on a property clause ?

IS it possible to built the oracle database without setting the kernal parameters?

How to use values from other tables in update statements using oracle?

How to generate query output in html format?

What is the difference between 10g OEM and 11g OEM?

How to open and close an explicit cursor in oracle?

Explain the difference between replace() and translate() functions in oracle?

How many types of synonyms in Oracle?

what are actual and formal parameters?

For more Oracle General Interview Questions Click Here