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
What are a cluster and non-cluster index?
How to start your 10g xe server from command line?
What are operators in oracle?
Is there an oracle sql query that aggregates multiple rows into one row?
What are the common oracle dba tasks?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
What is the dynamic sql in oracle?
How many types of segments in Oracle?
What happens if you lost a data file?
What are the differences between number and binary_float in oracle?
Is there a combination of "like" and "in" in sql?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
what is normalisation?what are its uses?
What is the data pump export utility?
How to bring a tablespace offline?