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



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

Post New Answer

More Oracle General Interview Questions

1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.

1 Answers   Wipro,


Please explain compound trigger in oracle?

0 Answers  


I have a table like this Table Name:Products Productid Price 1 10 1 10 2 20 3 30 3 30 But i want to output like this. productid price 2 20. please replay me.

3 Answers   TCS,


why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?

1 Answers   Goldman Sachs,


Explain the difference between a procedure and a function?

0 Answers  


What is a Redo Log ?

3 Answers  


How to install oracle database 10g xe?

0 Answers  


How to find out what privileges a user currently has in oracle?

1 Answers  


What is the difference between count (*), count (expression), count (distinct expression)?

0 Answers  


Will you be able to store pictures in the database?

0 Answers  


When do you get a .pll extension in oracle?

0 Answers  


What is OCI. What are its uses?

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)