Data dodania Pytanie
2018-02-14 15:02 Dynamic expandable datatable with multiple mysql tables? »
I am working on dynamic j query data table where i want to show data from 3 tables. It should be expandable.I am done to achieve with 1 table. but aft...
(0) odpowiedzi
2018-02-09 08:02 Python - Flatten the list of dictionaries »
List of dictionaries: data = [{ 'a':{'l':'Apple', 'b':'Milk', 'd':'Meatball'}, 'b':{'favourite':'co...
(3) odpowiedzi
2018-01-24 07:01 How to use PostgreSQL ArrayAgg function on a grouped by query set in Django ORM? »
To keep it simple I have four tables(A, B, Category and Relation), Relation table stores the Intensity of A in B and Category stores the type of B. A...
(0) odpowiedzi
2018-01-15 09:01 How to do JOIN query and not ignore records with NULL values? »
I have 3 tables in my Postgres database: users Column | Type --------+----------------------- id | integer n...
(3) odpowiedzi
2018-01-13 10:01 Get ONE value from three different tables gives wrong result - postgresql »
The goal is to get ONE value of remaining time on a task. I know that I cannot sum two joined tables, but this simple query get me confused: CREATE T...
(2) odpowiedzi
2018-01-11 07:01 Change join query to laravel »
I have a mysql query SELECT a.`head_id` AS "Headid",a.`name` AS "HeadName", b.`id` AS "Emp_ID",b.`name` AS "Emp_name" FROM users a join users b ON a...
(1) odpowiedzi
2018-01-10 14:01 Left join big DataTables in C# »
I have 3 big tables in SQL Server: Table1 (ID1, ..., ID2) => around 3 million rows Table2 (..., ID1, ...) => around 50000 rows Table3 (..., ID2, ......
(0) odpowiedzi
2018-01-06 17:01 Mysql make 3 queries in 1 and improve performance »
I'm trying to create a report and running 4 queries, but performance is so terrible. I'm using 2 tables This one has 2500 items in it CREATE TABLE ...
(1) odpowiedzi
2018-01-03 15:01 Is it a good approach to make a 'count' column in a comment system? »
In my system, there are entities(posts) and comments. Let's say there are two tables: 'comments' table and 'entities' table Comments table has a for...
(2) odpowiedzi
2018-01-02 21:01 SQL performance of self JOINs »
I'm learning self-joins and I notice there are two kinds of statement: -- use from ... where .... like cartesian select e1.name as employee, e2.name ...
(2) odpowiedzi
2017-12-26 12:12 How to use JOIN in mysql to show all data which are not matching »
I want to show data from 2 tables and I want to show them all including data that are not matching. I've tried with this query. SELECT * FROM student...
(2) odpowiedzi
2017-12-23 07:12 SQL Group By + Aggregate functions with joins »
I have two tables: 1. EMPLOYEE_DATA and its columns as EMP_ID MANAGER_ID 9999 2222 8888 2222 7777 2222 Another table is : 2. EMPLOY...
(6) odpowiedzi
2017-11-28 12:11 SQL join to join values in primary table with child table values as diffrent columns in a single row »
I have a survey_datas table contain data's as like this survey_data_id | title 1 | Paul 3 | Anna 4 | A...
(1) odpowiedzi
2017-11-25 13:11 SQL Query JOIN on the same table for a given data »
I have the following table and data: CREATE TABLE TEST_TABLE ( ID NUMBER(6) NOT NULL, COMMON_SEQ NUMBER(22), NAME VARCHAR(20), CONSTRAINT PK_...
(2) odpowiedzi
2017-11-24 10:11 PostgreSQL : SQL Request with a Group By and a Percentage on two differents tables »
I'm currently blocked on an complex request (with a join): I have this table "DATA": order | product ---------------- 1 | A 1 | B 2 ...
(1) odpowiedzi
2017-11-23 08:11 mySQL - Multiple rows into one row »
I need data from multiple tables using joins. Below are the tables. table 1 : list_vehicles pk_vehicle_id vehicle_reg_no vehicle_type 1 ...
(1) odpowiedzi
2017-11-21 06:11 Why does PostgreSQL throw "FULL JOIN is only supported with merge-joinable or hash-joinable join conditions" »
Trying to join 2 tables with an OR condition like this: FULL JOIN table1 ON (replace(split_part(table1.contract_award_number::text, ' '::text, 2...
(2) odpowiedzi
2017-11-20 20:11 Postgres complicated full outer join keeping nulls from the "on" column »
I have written a PostgresSQL query that is relatively performant at scale and gives me the dataset I want back, but I am wondering if it is the simple...
(2) odpowiedzi
2017-11-17 17:11 SQL : Multiple left joins with similar tables »
I have the following tables: TABLE A id info TABLE B f_id question choices TABLE C f_id question lines The id from the Table A always match a f_i...
(3) odpowiedzi
2017-11-16 15:11 SQL - How can I JOIN two tables and SUM a column based on IDs between them? »
I have two tables. One table is with master data Table tbl1: +-------------+------------+------------+ | ID | Name | Total | +-...
(3) odpowiedzi
2017-11-11 00:11 How to get all users that the logged in user is not friends with in MySQL? »
I am fully able to get all of the logged in users current friends, which I do with this query here - SELECT users.* FROM users LEFT JOIN friends ON ...
(4) odpowiedzi
2017-10-30 13:10 Query with multiple joins - postgres »
I have a postgres query with joins on 8 -9 tables and it takes quite a lot of time. Most of the columns used in the query are indexed (BTREE). Now I w...
(0) odpowiedzi
2017-10-23 20:10 Rails 5 - Joins null association without using join? »
What do I want What I need to get all orders without acceptance for a given user, but I'm having issues with the first part only. What do I have He...
(1) odpowiedzi
2017-10-14 07:10 Mysql: 2 different queries on same table with count and group by »
I have a table entries with the following columns: id, email, sku, payment, created_at I need to write a few queries to get some analytics on the en...
(1) odpowiedzi
2017-10-13 11:10 MySQL SELECT/JOIN query cause deadlocks on production DB »
Following SQL query cause deadlocks on production MySQL DB on a Wordpress site with heavy load. SELECT lessons.ID AS lesson_id, ...
(0) odpowiedzi
2017-10-11 16:10 Combine three tables to make an updatable new table »
Is there any way (except views) to create a new table in mysql that combines data from three or more different tables and when inserting new records i...
(1) odpowiedzi
2017-10-03 12:10 JOIN THREE TABLES IN CODEIGNITER »
I have three tables 1.article (id,article_title) 2.article_status(id,article_id,stage_id) 3.article_stages(id,stage_name) Each article have multip...
(4) odpowiedzi
2017-09-25 04:09 Trouble with my Query »
I have made a simple database application however I am having trouble adding in one final Column. The amount column needs to be populated with the Yea...
(1) odpowiedzi
2017-09-22 10:09 Integrity constraint violation: How to join two tables »
I am making a program for a school project in laravel, so I try to join two tables: products and destinations The table Product has the columns: id,...
(2) odpowiedzi
2017-09-10 21:09 Rails extract values with join associations »
I have a rails join table between 2 models superhero and superpower. Now I have 3 different superpower id and I want all the superheroes which have al...
(2) odpowiedzi
2017-09-04 16:09 PG::UndefinedTable: ERROR: missing FROM-clause — Searching with two models Rails »
I have a searchbar on my landing page where I can search for books from users from different universities. It doesn't seem to accept the .joins when i...
(2) odpowiedzi
2017-08-20 12:08 Ruby on Rails - Joins models for getting notifications »
In my application I have models User, Post, Notification, PostShare & SocialPage. This is how I've my models associations: class User < Activ...
(1) odpowiedzi
2017-08-19 16:08 is two inner joins is best for optimization of query »
i just got a challenge from school optimise this query this is theoretical question Challenge : SELECT TO_CHAR(CONVERT_TIMEZONE ('UTC','America/Los_...
(2) odpowiedzi
2017-08-14 18:08 mysql join 3 tables related in pairs »
► Context : I work in a museum (for real), people come everyday, they buy tickets for themselves (humans) and sometimes they also buy tickets for dr...
(1) odpowiedzi
2017-08-13 19:08 data.table update join using a constant »
I'd like to update a subset of rows in a data.table based on a join and a fixed value. d1 <- data.table(A = 5:1, B = letters[5:1]) d2 <- d...
(2) odpowiedzi