Given Kusto query Table | where type == "TYPE" | summarize lastEventTime = arg_max(lastEvent, *), vmCount = count(), onboardedCount = countif(onboarded), failVM = make_list_if(entity, onboarded == false and isnotempty(entity)), allVM = make_set(entity) by environmentType, osType, id , type Now I…
Is it possible to combine these two queries into one ? Meaning: Take the first row if media_group is NULL, otherwise take all rows with the same media_group $get_first_record = R::getRow( 'SELECT * FROM `prn` order by id asc LIMIT…
I'm trying to create a trigger, where inserted certain value in column if one value "currentAttemptCount" becomes equal or more to another "attemptCountLimit" from another table i have two tables @Table(name = "course_items") public class CourseItem { @Id @Column(name =…
I have a data table like the name as data_table and sample data are like below id name type temp_id 1 n1 t1 1 n1 t1 1 n1 t1 1 n1 t1 2 n1 t1 2 n1 t1 2 n1…
UNION can be used to merge the rows of two sub-requests: SELECT column_name FROM table1 UNION SELECT column_name FROM table2; By default, MySQL's UNION is actually UNION DISTINCT, which means that the rows table1 and table2 have in common are…
I have a list of products, and a list of related products. I know I can retrieve the list of products, then retrieve the list of related products, using two SQL queries. But I need to return the list of…
I have the task of finding all unique data types in all the tables. This is how I wrote the SQL query: WITH UniqueColumnTypes AS ( SELECT table_name, COUNT(DISTINCT data_type) AS unique_types FROM information_schema.columns WHERE table_schema NOT IN ('pg_catalog', 'information_schema')…
In a Postgres db, I have a view called school_id_cards. The view captures a list of id cards per school and student in a school system. ID cards are periodically reissued to students, so there may be any number of…
I have a situation where I need to insert data into two tables, where the inserted data is derived from the same long sub query. I know that CTEs can be helpful in similar situations since you can define a…
I have a simple MySQL table which consists of a primary key ID field, a timestamp (integer) field, and a foreign key ID field (device_id). There are indexes on each of these columns: mysql> show indexes from device_heartbeats; +-------------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ |…