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
- 6058 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 is deploy, process and build? : sql server analysis services, ssas
What is sql server 2000 work load governor?
What stored by the tempdb ? : sql server database administration
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
What is stored procedures?
Write a sql query to sort on different column name according to the parameters passed in the function?
What is TDS(Tabular Data Stream) Gateway?
What is compression - row-level and page-level compression?
How to retrieve field values using mssql_result()?
Explain the database you used in your final year project?
Why use sub query in sql server and list out types of sub queries?
Can we use pragma autonomous_transaction in trigger?
Find first and last day of current month in sql server
Can truncate be rolled back?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
