I have a website that allows customers to browse and place
orders for certain products.
I have 2 tables; Customers and Orders. The Customers table
holds the customer records and the Orders table
holds the orders placed by the customer. Both tables are
tied based on the field Cust_ID.
Example of the data is shown below:
Cust_ID Cust_Name Cust_ID Product Amount Order_Date
1001 John Tan 1001 P-5211 $120.00 2/13/2006
1002 Michael Wong 1001 K-1428 $88.90 1/11/2006
1003 Mary Cheong 1003 C-0923 $82.50 1/27/2006
1004 Ahmad Suffian 1003 K-1428 $88.90 2/2/2006
Write a single SQL statement that extracts all purchase
records with the following criteria:
1. Customer names starting with “M” only.
2. Orders placed within the current month only.
3. Amount does not exceed $100.00
The list must be sorted by order date with the latest order
showing on top.
- 3 Answers
- 5172 Views
- Techno Solutions, I also Faced
- E-Mail Answers
Answer Posted / santhi kandasamy
In oracle.,
Select * from customers, orders where
CUSTOMERS.CUST_ID=ORDERS.CUST_ID AND
Cust_name like 'M%' AND
TO_CHAR(orderdate,'mm,yyyy')= TO_CHAR(sysdate,'mm,yyyy') AND
SUBSTR(amount,2)<=100.00;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
List some of the rules that apply to creating and using a ‘view’
What do you understand by replication in sql server?
What is the command dbcc checkdb used for?
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What is the purpose of a table?
What does sql server mean?
What is a non clustered primary key?
What are the restraints imposed on the table design by a merge replication?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
Explain cursor as data base object?
What are the different kinds of ssrs reports?
What is transaction server explicit transaction?
What are the types of normalization?
Can you move the resources after pausing the node? : sql server database administration
