python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - mysql

how to create a view with output grouped by calendar week

My database table is id kecamatan tanggal 1 AA 02-01-2022 2 AB 03-01-2022 3 AA 10-01-2022 4 AB 12-01-2022 5 AA 17-01-2022 6 AC 18-01-2022 I want this result, because I can not re...
test-img

Dimas Cornellya Agatta

html

mysql

codeigniter

Votes: 0

Answers: 0

SQL aggregate function with if condition

I'm wondering if I can perform count function on different status_id with condition when status_id is X then something This is my current query: select count(*), status_id from users group by status_i...
test-img

Mike Ross

mysql

sql

Votes: 0

Answers: 2

Latest Answer

The easiest way is: SELECT COUNT(*), status_id FROM users WHERE status_id NOT IN (18, 24, 25) OR active = true GROUP BY status_id
test-img

Oleksii Tambovtsev

NodeJS Promise randomly returning undefined value

Firstly I'm sorry if this has already been answered, but I have searched for this kind of issue without finding anything useful. I'm developing a NodeJS application that has to query a database with t...
test-img

nyzc

javascript

mysql

node.js

async-await

es6-promise

Votes: 0

Answers: 1

Latest Answer

As depicted in Edit 1, the issue was a shared loop counter. One of my colleagues forgot to add the let keyword before iterating, so the for loop was jumping values. I now hate this javascript feature....
test-img

nyzc

Query to retrieve recursively parent child nested list joining to another two tables MySQL-PHP

I've 3 tables and I want to joint them based on the following conditions. My first table is called components it has the main parent and it has a sub-component called sub_compnents which holders the c...
test-img

Girmangus Hailu

php

mysql

codeigniter-3

mariadb-10.4

Votes: 0

Answers: 1

Latest Answer

You can use a recursive cte to retrieve the activities and join them to sub-components and components. Storing the full hierarchy in your adjacency list would make things easier but I am assuming ther...
test-img

user1191247

Posts

Questions

Blogs

Jobs