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
- 6256 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
When would you prefer to have a minimum number of indexes?
What is compression - row-level and page-level compression?
How you provide security to cube? : sql server analysis services, ssas
How to turn on the mssql api module in php?
How to create an inline table-valued function?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
Explain database normalization?
Explain what is use of dbcc commands?
How you can change the database name in SQL SERVER?
What is dirty read?
List out the differences between global and local temp tables in sql server?
What is indexed view?
Would you store your query in a ssrs report or a database server? State the reason why?
What are the differences between ms sql server & oracle?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
