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
- 5428 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
How many categories of data types used by sql server?
What is scalar user-defined function?
Which are the new data types introduced in sql server 2008?
Define outer join?
How to create a stored procedure with a statement block in ms sql server?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
Does transparent data encryption provide encryption when transmitting data across the network?
How to invoke a trigger on demand?
Please differentiate between a local and a global temporary table?
How to find the second highest salary of an employee?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
What is trace flag in sql server?
What are the five major components of a dbms?
How to use subqueries with the exists operators in ms sql server?
Do you know what are the ways available in sql server to execute sql statements?
