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
- 5271 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / name
select client_name,count(item) from clients where item=
(select Item from items )
having count(item)>3
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / rharshad
select client_name,count(item) from clients where item in
(select Item from items )
having count(item)>3
| Is This Answer Correct ? | 1 Yes | 2 No |
select * from emp what happened internally when we write this query in the sql prompt?
How to define Data Block size ?
Explain the use of log option in exp command.
How to view existing locks on the database?
What is a parameter file in oracle?
How would you begin to troubleshoot an ORA-3113 error?
How to drop an index in oracle?
what is the output of select * from emp where null=null & select * from emp where 1=1
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?
What do you mean by a deadlock?
What are the different types of failures that occur in Oracle database?
Oracle General 
