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 5380

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

1773

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.

1593

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

1578

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 4232

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

2 4160

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

2 4595

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

5 6538

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

1 3711

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

1580

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

1752

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

2 3910

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 5927

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 2235

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 13481

Post New Wipro Oracle General Interview Questions


Wipro Oracle General Interview Questions


Un-Answered Questions

What are the purpose of @ngmodule?

436


My question is abt backlog.I had dropped one subject in my second year, and completed this subject in the 3rd attempt, so how many backlogs i have got?1 or 3?plz sujjest the answer as soon as possible

1571


What is spark catalyst?

187


Is scala good for machine learning?

1


Give a big picture of the entire SRAM Layout showing your placements of SRAM Cells, Row Decoders, Column Decoders, Read Circuit, Write Circuit and Buffers

608






What is lightning experience? : salesforce lightning component

202


How do the amoeboid movements occur?

457


Which is better hibernate or jdbc?

258


What does ibm mq mean?

518


What are the most commonly used multi backgroud properties in css3?

238


What is flashback in Oracle?

560


How do I remove line numbers?

426


Explain how you can reduce the resource requirement in jmeter?

300


What is 'mounting' of volumes ? Is there anything that a programmer can do in it ? How to find currently mounted volume ?

1965


Is php worth learning in 2019?

482