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
- 5406 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 to get a list of all user accounts in the database?
What is merge in oracle?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How to pass a parameter to a cursor in oracle?
What is a tns service name?
what are the advantages of running a database in archive log mode?
Hi Can any one tell me what are the API's used in requisition import.
What is the recommended interval at which to run statspack snapshots, and why?
How to define an external table with a text file?
Can we store images in oracle database?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
How to add a new column to an existing table in oracle?
How to build data dictionary view an new database?
What privilege is needed for a user to insert rows to tables in another schema?
How to convert characters to numbers in oracle?
