Interested to Buy Any Domain ? << Click Here >> for more details...
23. Display the client name for all clients who have placed
an order where any order line has more than 3 items. Do not
use a table join anywhere in your query.
- 3 Answers
- 5365 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / hrishi
select order_no,count(item_id) from client_order
group by order_no having count(item_id)>3
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are the differences between lov and list item?
What is a Garbage Collection? and what is full recursive Garbage collection?
How can we find out the current date and time in oracle?
How to assign values to data fields in record variables?
What is Data Dictionary Cache in Oracle?
What is an Oracle Instance?
What happens to the current transaction if the session is ended?
What is data block in Oracle?
What are advantages of dateset in datastage?
What would you do with an in-doubt distributed transaction?
What is data type in oracle?
How to create a testing table in oracle?
What is Library Cache in Oracle?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
Explain user account with reference to oracle.
