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
- 5944 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 the difference between function and stored procedure in sql server?
What is trigger in salesforce?
What happens if null values are involved in boolean operations?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
What is apply operator in sql?
What are the types of normalization?
What are the benefits of filtered indexes?
What is exclusive locks?
Explain contrast amongst grouped and non-bunched records?
Explain what is lock escalation?
Write a code to select distinct records without using the DISTINCT keyword.
Tell me about pre-defined functions of sql?
Where are sql server user names and passwords stored in sql server?
Mention the differences between substr and charindex in sql server.
List out the difference between union and union all in sql server?
