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
- 5535 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
How do I spool to a csv formatted file using sqlplus?
How to create additional tablespaces for an new database?
defination of bitmap index
What is Data Dictionary Cache in Oracle?
How do I start tns listener?
How to filter out duplications in the returning rows using oracle?
How to use null as conditions in oracle?
What are the tools for Oracle ?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
What is oracle latest version?
List the types of joins used in writing subqueries?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
How can I introduce multiple conditions in like operator?
How do you store pictures in a database?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
