I have a table with the following example data: ID Name lat long 1 100 123 -123 2 101 234 -234 4 100-L NULL NULL 5 100-R NULL NULL 6 101-L NULL NULL 7 101-R NULL NULL What I need…
I have a table like below: id device_id device_model 1 101 A 1 201 B 1 202 B 2 102 A 2 301 C 3 103 A 3 203 B 3 302 C I want to select group of ids…
ID title category 1 test a 1 test b 2 test2 c 2 test2 d 3 test3 e 3 test3 f I have a table like above in mysql. I want to group the "category" with the same ID as…
Get a column with total sale by each agent and second column with total sale for company as well in each row I have 3 tables, queries added below for table schemas and data. I want to get total sales…
Essentially I am trying to produce the following SQL query via Linq: SELECT * FROM `CustomerMainTable` AS `t` WHERE `t`.`CustomerMainTableId` IN ( SELECT MAX(`t0`.`CustomerMainTableId`) FROM `CustomerMainTable` AS `t0` GROUP BY `t0`.`CustomerMainTableCustomerId` ) CustomerMainTableId is an autoincrement id, and CustomerMainTableCustomerId is…
I have the following query insert into T1 (code, code2, type, is_default, m_order, m_type, title, created_by) select t.* from (select a.code from (select code from T2 where type = 171 and value = 'ABC') a, select b.code from (select code…
I want to generate report in phpmysql in such a way that first detail rows display and in the bottom , sum of that detail row display on the basis of group by statement. Select id, Emp-name, department, salary, sum(salary)…
How do I write a LINQ query that would translate to the following SQL? SELECT u.id, u.username, a.id, MIN(a.created_at) AS firstArticle FROM users u INNER JOIN editorial_articles a ON a.user_id = u.id GROUP BY u.id ORDER BY u.id, a.created_at, a.id…
com_cards_charge : com_cards_charge table(DB) com_debt : com_debt table(DB) some of result: Result1 Result2 SELECT * FROM com_cards_charge, com_debt where com_debt.com_debt_cards_charge_id = com_cards_charge.com_cards_charge_id AND debt_Creditor_type in (0, 15) AND com_cards_charge_deleted = '0' GROUP BY com_cards_charge.com_cards_charge_id order by com_cards_charge_id DESC This query…
Is there a way to make an entire row unique no matter what value the column is in? So, if 1 is in col a, and 2 is in col b, then if you were to insert 2 into col…