Interested to Buy Any Domain ? << Click Here >> for more details...
3. Display all the client numbers in the ORDER table. Remove
duplicates.
- 1 Answers
- 4442 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / aswini
select distinct client_number from <table_name>;
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to create a stored procedure in oracle?
Difference between cartesian join and cross join?
How to load excel data sheet to oracle database
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What is the difference between alert log file and tarce file ?
Who developed oracle & when?
When do we use group by clause in a sql query?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How to create an oracle database manually?
How to use regular expression in pattern match conditions in oracle?
How do we represent comments in oracle?
Explain the difference between replace() and translate() functions in oracle?
How to view all columns in an existing table?
How to loop through a cursor variable?
what happened to the global index when I truncate the data in one of the partition?
