group by extract() error - NexusDB Newsgroups

		NexusDB Newsgroups > Support Newsgroups > nexusdb.public.support.sql
group by extract() error

30th June 2004, 11:54 PM

jay smurch

Posts: n/a

group by extract() error

I run this, to get a count of items by year, I get an error saying the
EXTRACT in line 3 is an invalid SQL name.

SELECT EXTRACT(YEAR FROM dt), count(*)
FROM "transactions"
GROUP BY EXTRACT(YEAR FROM dt)

"dt" is a Date column. Isn't this supposed to work?

Regards.

« Previous Thread | Next Thread »

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

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Error: Error: NexusDB: <unnamed TnxQuery instance>: Query execution failed	Warren	nexusdb.public.support.adoprovider	1	8th April 2010 02:55 PM
Error SQL for Insert with Group with Non-aggregate column (constant)	hhlee	nexusdb.public.support.sql	11	21st November 2003 10:53 PM
Question on Extract/subquery	Don Miller	nexusdb.public.support.sql	20	11th October 2003 08:26 PM
NX1.01: Cast with Group By Error	Joao Borges	nexusdb.public.support.sql	3	10th October 2003 05:19 AM
NX1 - 'Select' Extract incorrect record when it work with Chinese	Forest Greenland	nexusdb.public.support.sql	0	29th September 2003 10:33 PM

All times are GMT +11. The time now is 02:21 AM.