Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5945 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
ORDER BY ORDERDATE DESC;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How can you ensure that the database and sql server based application perform well?
Do you know what is difference between index seek vs. Index scan?
How to skip remaining statements in a loop block using continue statements?
Explain about merge replications?
What is ms sql server triggers?
What is usually the first word in a sql query?
What are the properties of primary key?
what is the system function to get current user's user id? : Sql server database administration
How to add a new dsn with the odbc driver for sql server?
How you trouble shoot when any job fails
do views contain data ?
what is spatial nonclustered index
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
What are the steps you must follow to hide sql server instances?
How you can get a list of all the table constraints in a database?
