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
- 5338 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
What are differences in between sql server 2012 and sql server 2016?
Define tempdb database?
What is right outer join in sql server joins?
What is the use of builtinadministrators group in sql server? : sql server security
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
What is a heap?
What are system databases into sql server (2005/2008)?
How to apply cascading referential integrity in place of triggers?
How to create a login account in ms sql server to access the database engine using "create login" statements?
What are ddl (data definition language) statements for tables in ms sql server?
How do I know if localdb is running?
Explain try...catch with sql server?
What is a self join in sql server?
What is the command used to check locks in microsoft sql server?
How many types of attribute relationships are there? : sql server analysis services, ssas
