Simple SQL statement to retrieve orders on a specific date
matters1776
I'm having trouble crafting a simple SQL query that retrieves the number of orders placed on 7/15/1998, which includes the date in the result. The label number of orders should be "OrderCount".
This is what I have got so far without success.
SELECT SUM(OrderT.CID) as OrderCount
FROM OrderT
WHERE OrderT.CID= #7/15/1998#;
Here is a screenshot of the database:
xNeyte
SELECT OrderDate, COUNT(OrderID) AS OrderCount
FROM OrderT
WHERE OrderDate = #1998-07-15#
GROUP BY OrderDate;
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: Converting a method to use any Enum
- Next: How can I add the name of a contact to my table view cell?
Related
Related Related
- 1
Simple SQL statement to retrieve orders on a specific date
- 2
Simple SQL query: Retrieve a value depending on a date?
- 3
Simple SQL query: Retrieve a value depending on a date?
- 4
Selecting a specific date with a PL/SQL statement
- 5
SQL query to retrieve WooCommerce orders grouped by state
- 6
a simple select SQL statement
- 7
I can't retrieve the Date greater than or equal to a specific date in Sql.
- 8
Retrieve output parameter of SQL statement
- 9
How does one retrieve records 1 year prioir from specific date in sql server 2012
- 10
Error on Simple SQL Update Statement
- 11
How to retrieve data on specific date in Android database
- 12
SQL Statement to retrieve information from multiple tables
- 13
Prepared Statement does not retrieve the exact result of the sql
- 14
How to retrieve single data in SQL statement?
- 15
If statement is 1 then run specific SQL statement
- 16
SQL Statement with 3 References and Date Statement
- 17
Finding a Specific Character in SQL Statement
- 18
Cannot compare date in SQL statement
- 19
SQL statement - join based on date
- 20
Nested case statement in sql for date
- 21
SQL statement for starting date and over
- 22
Cannot compare date in SQL statement
- 23
SQL statement - join based on date
- 24
Simple SQL Query for date ranges
- 25
Retrieve a record that has 2 specific features in SQL
- 26
SQL PHP Retrieve total money for a specific Store
- 27
Sql Server retrieve last date for multiple records
- 28
Explain Merge SQL Statement in Simple Words?
- 29
Access VBA simple sql select statement
Comments