Tag: sql

Combine 2 tables without primary key

I have 2 tables and wanna combine as below Table Student: Student ID | Student Name ———–+————- 100 John 101 Micheal Table Subject: Subject Name | Subject Desc –…

Find Duplicates on Multiple Criteria

google-sheets pandas python sql

I have a set of financial transactions with a Date, Amount, Description and Source and I want to find transactions where the amount is the same, the date is within one day, but the sources are …

Using CASE WHEN DATE Statement in MariaDB 10.2.15

mariadb mysql pivot-table sql

I created a query to display the ScanIn Field in one month on each date Code : SELECT Employee.Name, CASE WHEN DAY(LogsFormatted.DateIn) = 1 THEN LogsFormatted.ScanIn ELSE ‘-‘ END AS ‘1’, …

Fetching constraints in SQL database to JSON in PHP

arrays json mysql php sql

Let’s assume I have the following database structure of car manufacturers and the corresponding cars: manufacturers: cars: The id column of manufacturers is the primary key and the manufacturer column of cars has the corresponding foreign key constraint. I’d like to produce the following JSON outp…

how to select non repeated date intervals?

database sql

My products table, year 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005 2004 2003 2002 2001 2000 My Query, SELECT dt||’-‘||dt1 FROM (SELECT year as dt, year+4 as dt1 FROM products GROUP BY …

Update large table from smaller, mission critical, table without locking small table

innodb mysql sql

In MySQL, I have two innodb tables, a small mission critical table, that needs to be readily available at all times for reads/writes. Call this mission_critical. I have a larger table (>10s of …

Will the constraints remain after Importing table from RDBMS to HIVE with sqoop?

cloudera hive rdbms sql sqoop

When we use sqoop import to transfer an RDBMS table to HIVE, will the constraints of the table such as primary key remain ? i.e. will the column of the table which is the primary key remain as …

Joining in SQLite to get desired records

join relational-database sql sqlite

I am working on a mobile application which takes two inputs – Source Station Name and Destination Station Names. Upon receiving these two inputs, the application would then enlist the names of trains …

For all pairs of reviewers such that both reviewers gave a rating to the same movie, return the names of both reviewers

sql sqlite

Stanford Self Paced Course for SQL question: For all pairs of reviewers such that both reviewers gave a rating to the same movie, return the names of both reviewers. Eliminate duplicates, don’t pair reviewers with themselves, and include each pair only once. For each pair, return the names in the pair i…