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
- 5273 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 is user managed backup in Oracle?
What happens if variable names collide with table/column names?
How to connect ms access to oracle servers?
What is the use of oracle?
How many types of database triggers exist?
Explain cascading triggers.
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
How to create id with auto_increment on oracle?
What do you understand by a database object?
How to get the Installed Oracle Version Information ?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
What are internal user account in oracle?
defination of bitmap index
How to fetch the row which has the max value for a column?
How translate command is different from replace?
