Radicore Forum: How To » Customizing the SQL statement

Home » RADICORE » How To » Customizing the SQL statement

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Customizing the SQL statement [message #859 is a reply to message #858]

Tue, 29 May 2007 06:06

salamsy
Messages: 18
Registered: October 2006
Location: Dakar

Junior Member

Hi,

This query runs on a single table "awl_leader". It counts the number of records and gives a total for each column specified in GROUP BY.

"select lea_region, lea_degree, count(lea_id) from awl_leader group by lea_region, lea_degree with rollup"

Thanks.

Abdou Salam

Abdou Salam

Report message to a moderator

[Message index]

		Customizing the SQL statement By: salamsy on Mon, 28 May 2007 08:38
		Re: Customizing the SQL statement By: AJM on Mon, 28 May 2007 11:45
		Re: Customizing the SQL statement By: salamsy on Tue, 29 May 2007 06:06
		Re: Customizing the SQL statement By: AJM on Tue, 29 May 2007 08:20
		Re: Customizing the SQL statement By: salamsy on Tue, 29 May 2007 08:46
		Re: Customizing the SQL statement By: AJM on Tue, 29 May 2007 09:11

Previous Topic:	Using dropdown
Next Topic:	mnu_task.pattern_id='SEARCH'

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Nov 27 06:22:19 EST 2024

Total time taken to generate the page: 0.01005 seconds