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
- 6099 Views
- Techno Solutions, I also Faced
- E-Mail Answers
Answer Posted / bobby
IN SQL SERVER
select * from (select
c.cust_ID,Cust_Name,product,Amount,order_Date from Customer
c join Orders o
on c.cust_Id=o.cust_ID)p where Cust_Name like 'M%'and
(datename("mm",order_Date)=datename("mm",getdate()))
and amount<100 order by order_Date desc
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to insert multiple rows with a subquery?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
What is the maximum length of an alert name?
How will you hide an attribute? : sql server analysis services, ssas
Define constraints and give an example of their use?
What structure can you implement for the database to speed up table reads?
What is indexed view? How to create it?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
Explain in brief about Microsoft SQL server?
Which autogrowth database setting is good?
What is extended stored procedures?
How to enter comments in transact-sql statements?
How do I make a resultset scrollable?
What are various limitations of the views?
Can multiple columns be used in sql group by clause in ms sql server?
