19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.
2 542220. Using a set operator, display the client number of all clients who have never placed an order.
179521. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
161822. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
160023. 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 428624. Display the order number for all orders whose average item cost is greater than the overall average item cost across all orders.
2 420325. Display the client number and the value of the highest value order placed by that client.
2 46251. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.
1 37342. Display the post code and the total number of purchase orders placed with creditors in that post code.
16023. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.
17734. Using a set operator, display the creditor number of all creditors who have ever been paid.
2 39495. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.
6 5985I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
1 2271write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
11 13621Post New Wipro Oracle General Interview Questions
How do I control what happens when I start the ms word?
what does a k rating in a transformer means?
what are the things i had to say in personal introduction in hr round mail me to prasanna.1867@rediff.com
Can you suggest me some good reference books on ADR/GDR/IDR which covers history, objectives, problems, theory and workings of GDR.
What tasks does the pactv feature perform?
What is a union?
Explain about drupal version release dates?
How many codes are used when u design a Pressure Vessel
When to use coalesce and repartition in spark?
Will it be great to invest on hotel carpets for the hotel interior?
Explain function overloading and operator overloading.
Where do we use am and fm?
Which are the biggest cats; tiger or lion?
why context switching time should be minimum? How it depends on hardware support?
what would be main different environment in gsm and cdma core networking side?