NAVIGATION
CATEGORIES
REFERRENCE
LINKS
Date
1 answers - 256 bytes -
Hi
i have the following records and i want to select November records only.
1/12/2004
2/12/2004
1/11/2004
2/11/2004
so what is the best SQL statement to get the answer?
Note : i m using Access Database
thanksNo.1 | | 82 bytes |
| 
Hi, try this
Select * from Table where month(datefield)=11
Madhivanan
QUESTION ON "Database"
- datawarehouse and MDX, the only way?
- deadlock
- Deadlocks on multiprocessor MSSQL server
- DB2 performance (waits)
- Db Schema in MFC app
- DB_VARNUMERIC data
- DB synch for out of network clients modlesa adn practices?
- DB2 connection string
- DB2 Incremental BackUP / Restore problem from one machine to another
- ^M characters in postgresql output
- [SQLServer Express]how to copy a database to another computer
- [SQL][ORACLE] Greater-than operation on grouped data
- A database that supports Windows mobile, Palm, Symbian, Blackberry etc.
- a newbie problem
- a question for procedure
- A question about Oracle stored procedure
- A tricky sql question
- a sql query
- About encoding issue in MySQL
- creating dynamic query
- DB rows/records as oo-objects?
- Access DB Application Locks Up
- access 97 to 2000 conversion with ADO
- data convirsion
- Data Synchronisation
- how do i use MFC to access Access tables database?
- how does oracle deal or transfer large data ?
- How much storage space does nvarchar() eats? Always max?
- Help with INNER JOIN
- Help!
- Help with SQL Query
- Help with normalizing a table...
- How to retrieve length of column from MS SQL table
- how to set the max no of rows in table
- How to delete all the data in a database?
- How to convert from UpperCase to TitleCase
- how to create Multi values field
- Interesting question on Select - Oracle DB
- Informix - INSERT INTO issue
- Inserting data into multiple tables