What are alternate keys?
No Answer is Posted For this Question
Be the First to Post Answer
How to select an exiting database using mssql_select_db()?
What are ddl (data definition language) statements for tables in ms sql server?
Which are the new data types introduced in sql server 2008?
Can we insert data if clustered index is disabled?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
how to overcome kernel isssues
What is the maximum length of an alert name?
What is ACID Property of Transaction?
How to stop a loop early with break statements in ms sql server?
What is resource governor?
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.