mysql - SQL: COUNT() grouped results -

-

this current query:

select locationname, eventid events group locationname order locationname asc

as can see it's grouped locationname because there several rows same locationname.

in output need list of "distinct" (grouped) locations behind every location there should total amount of each location.

so if in "events" 4 locationsname "congress center nyc" output should "congress center nyc (4)".

is there way expand query count()?

thanks!

this straightforward aggregate query.

select locationname, count(*) number   events  group locationname  order locationname

if want specific formatting, can using first line of query.

 select concat(locationname, ' (', count(*), ')')

Comments

Post a Comment

Popular posts from this blog

php - Autoloader issue not returning Class -

-
problem? bootloader (autoloader) not seem working properly, or i'm missing something. here simplified code. the code below returns class "skeleton" not exist. on index.php file. index.php <?php include 'bootloader.php'; use skeleton\html\loginheader; $tool = new skeleton/html/loginheader(); bootloader.php <?php function boot($classname) { $filename = ''; $namespace = ''; // sets include path "src" directory $includepath = dirname(__file__).directory_separator.'src'; if (false !== ($lastnspos = strripos($classname, '\\'))) { $namespace = substr($classname, 0, $lastnspos); $classname = substr($classname, $lastnspos + 1); $filename = str_replace('\\', directory_separator, $namespace) . directory_separator; } $filename .= str_replace('_', directory_separator, $classname) . '.php'...
Read more

python - Getting next two indexes regardless of current index -

-
i trying create mock rock, paper, scissors game each name having 2 enemies, must able grab values of names regardless of position. say given list: names = ["kings", "queens", "jacks", "jokers", "masons", "warriors", "soldiers"] and trying use logic indexes being values , gather next 2 values of indexes. each index return these values. 0 - 1, 2 1 - 2, 3 2 - 3, 4 3 - 4, 5 4 - 5, 6 5 - 6, 0 6 - 0, 1 so 'warriors' have enemies of: soldiers , kings below being current implementation: def state_to_text(self): names = ["kings", "queens", "jacks", "jokers", "masons", "warriors", "soldiers"] if self.state == 0: return str(names[1], names[2]) if self.state == 1: return str(names[2], names[3]) if self.state == 2: return str(names[3], names[4]) if self.state == 3: return str(names[4...
Read more

ruby - Prevent Custom Validation Error on Association -

-
i have app list , email models many many association. want users able add many emails lists @ once, have function in controller split emails custom textfield in new list form "emails" array. i want validation error if it's blank added custom validation on field in lists model: class list < applicationrecord has_and_belongs_to_many :emails #tried adding ", validates: false" here too, didn't work #custom attr_accessor :emails validates :emails, presence: true end it works great, except when try associate existing email list (in case user entered 1 in db), validation error. oddly, can prevent validation error when associating net new emails lists "(validation: false)" seen below, not when email exists already, if add save function , append "validation: false". part of controller in question is: emails.each |email| if email.where(email: email).blank? db_email = email.new( email: email ) db_email...
Read more