help in sql query

houssam_ballout · 11-28-2006, 02:52 PM

hello all,
CAn u help me in the query, that returns certain fields between 2 dates?
thanks

codeman0013 · 11-28-2006, 02:55 PM

Yea thats a pretty simple one what are the names of the tables and fields and what do you want to return...

houssam_ballout · 11-28-2006, 03:02 PM

Table -> order
fields -> name, count
I have tried this
select name, count from order where orderDate between '26/11/2006' and '28/11/2006'
but it is returning 0 fields.....
any help

codeman0013 · 11-28-2006, 03:17 PM

This is a stupid question but you do have orderDate as a field right? Also you need to pull the order date somehow too..

11-28-2006, 02:52 PM	#1 (permalink)
houssam_ballout Diamond Member Join Date: May 2005 Location: here Age: 22 Posts: 1,016	help in sql query hello all, CAn u help me in the query, that returns certain fields between 2 dates? thanks __________________ TechNoloGy ConTrols tHe World AnD I conTroL the TecHnOl0gy Gue$s WhO @m i. HehEhehee :confused:

11-28-2006, 03:02 PM	#3 (permalink)
houssam_ballout Diamond Member Join Date: May 2005 Location: here Age: 22 Posts: 1,016	Table -> order fields -> name, count I have tried this select name, count from order where orderDate between '26/11/2006' and '28/11/2006' but it is returning 0 fields..... any help __________________ TechNoloGy ConTrols tHe World AnD I conTroL the TecHnOl0gy Gue$s WhO @m i. HehEhehee :confused:

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SQL query results again	dragon2309	Internet Discussion	16	01-13-2006 08:47 PM
Reverse SQL query results	dragon2309	Internet Discussion	5	12-30-2005 04:04 PM
sql server?	houssam_ballout	General Software	1	11-26-2005 04:54 PM
SQL Server 2000	dansilva	General Software	3	04-14-2005 12:04 PM
embedded sql with C help..segmentation fault?	loserpunkx182	General Software	0	12-08-2004 01:59 AM

11-28-2006, 02:55 PM	#2 (permalink)
codeman0013 Diamond Member Join Date: Jul 2006 Location: Inside my network at work Age: 23 Posts: 1,468	Yea thats a pretty simple one what are the names of the tables and fields and what do you want to return...

11-28-2006, 03:17 PM	#4 (permalink)
codeman0013 Diamond Member Join Date: Jul 2006 Location: Inside my network at work Age: 23 Posts: 1,468	This is a stupid question but you do have orderDate as a field right? Also you need to pull the order date somehow too..