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

Answer Posted / aswini

select distinct client_number from <table_name>;

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In oracle there is column command, how will you explain that?

554


WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

1705


6. Display the client name and order date for all orders using the traditional method.

1753


How to create an initialization parameter file?

543


What are the ansi data types supported in oracle?

521






What is an oracle wallet?

515


Explain the use of compress option in exp command.

552


Whether any commands are used for months calculation? If so, what are they?

598


How to connect the oracle server as sysdba?

633


WHAT IS ecc 6.0

1666


Explain do view contain data?

585


What's dateware house and what's clustor with practicle example

1643


If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

1739


hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

1759


How translate command is different from replace?

550