answersLogoWhite

0

I'm not familiar with MS SQL Server in particular, but all the SQL databases I've worked with are something like this: SELECT * FROM table WHERE date > '2006-12-01' AND date < '2006-12-31'; Double-check the date format - most are set to use a Year-Month-Day format, but some are different.

Yes The above query will work..

Select * from <table> where date>='mm\dd\yy' and date<='mm\dd\yy'

User Avatar

Wiki User

16y ago

What else can I help you with?

Related Questions

How do you validate and retrieve data from database?

How do you validate and retrieve data from database?" How do you validate and retrieve data from database?"


Queries are often used to do what?

A query is formulated to retrieve data that meets the query parameters. For example if you had a data base containing peoples names and ages, a query might be to retrieve all names who have an age between 25 and 30.


How do you retrieve data?

Data Miner


How is data input?

Data input is a file that contains data that serve as input to a device or a program input file.The dates have to be accurate in order to retrieve the data easily and first.


What do most users only retrieve data with?

data miner


What is the difference between reading data and writing data?

Writing data is when you store it. Reading data is when you retrieve what is already stored.This is really not much different than understanding the difference between writing something onto paper and reading something off of a piece of paper.


How do retrieve data from database in c?

nbbmnbmn


Can you retrieve your documents after installing Windows 7?

After reinstalling a operating system, it will be more likely that you have lost's the data. However, you could try a recovery data software, this will try and retrieve your data when deleted.


What is the name of a statement written to retrieve specific data from a table?

The name of a statement written to retrieve specific data from a table is a SQL SELECT statement.


What are data retrieval language commands?

Data retrieval language commands are used to retrieve specific data from databases. Common commands include SELECT (to retrieve data), WHERE (to set conditions for the retrieval), ORDER BY (to sort the retrieved data), and JOIN (to combine data from multiple tables).


What is back end testing?

It is a types of testing in which one will perform write query using sql statement whatever data you fill that data should be saved in back end . for eaxmple my sql,sqlserver, oracle like that so on.


Is it possible to retrieve data loss from flash memory using a USB extension cable?

No, it is not possible to retrieve data loss from the flash memory using the USB extension cable.