Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

Wipro Oracle General Interview Questions
Questions Answers Views Company eMail

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 4909

20. Using a set operator, display the client number of all clients who have never placed an order.

1539

21. 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.

1366

22. 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

1355

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 3607





24. Display the order number for all orders whose average item cost is greater than the overall average item cost across all orders.

2 3674

25. Display the client number and the value of the highest value order placed by that client.

2 4128

26. Display the earliest shipping date in the format: DD/MON/YYYY

5 5665

1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.

1 3336

2. Display the post code and the total number of purchase orders placed with creditors in that post code.

1360

3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.

1497

4. Using a set operator, display the creditor number of all creditors who have ever been paid.

2 3353

5. 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 5033

I 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 1837

write 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 11766

Post New Wipro Oracle General Interview Questions




Wipro Oracle General Interview Questions


Un-Answered Questions

How can i describe the blood?

1156


How do you rank data in sql?

304


Which language is used in unix?

281


Why do we use hashmap?

318


What is the mathed of maintain oxizen level in a air tite A/c room.

1312






What is Plan Depreciation(AFAB)

1258


How to decide CT & PT ratings for a given transmission line carrying some rated voltage?

1634


What do I do on the server to interact with an ajax client?

342


On a nexus, is the metric-type keyword not available in the "default-information originate" command?

416


Explain tc2 instances?

66


What is the formula you will use to calculate how many millilitres of 5.5 m naoh are required to prepare 400 ml of 1.5m naoh?

341


What is difference between rownum and rowid?

294


What is the different logging methods available?

285


What is a socket in linux?

316


Can I build a good future in "IT profile(non-BPO)" by joining as Technical support voice at IBM/ Wipro/Dell .....??? Please do guide me in this case...

1451