python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - legacy-database

Count Group By and Separate If Included in Both Group

Not sure if this question is duplicated yet or not. I have a simplified table below User Interest Jason Art Jason Sport Sam Sport Sam Art Steve Sport Desmond Sport Tania Art He...
test-img

Rama Ramadhan

mysql

sql

gql

legacy-database

Votes: 0

Answers: 2

Latest Answer

You could use conditional aggregation here: WITH cte AS ( SELECT User, CASE WHEN COUNT(CASE WHEN Interest = 'Art' THEN 1 END) > 0 AND COUNT(CASE WHEN Interest = ...
test-img

Tim Biegeleisen

postgreSQL 8.4.20: How to solve missing oldestXID in pg_control preventing use of pg_upgrade on a legacy CentOS 6.4 server?

My company has a legacy, internal server running CentOS 6.4 with postgreSQL 8.4.13. The goal is to upgrade it as far as possible without doing OS updates; it's a live internal server being used for se...
test-img

Scott

postgresql

centos

centos6

postgresql-8.4

legacy-database

Votes: 0

Answers: 1

Latest Answer

So, my friend asked me if I'd gone through the old source code looking for references, and I realized I hadn't because I hadn't been able to find the source. I looked around a bit more and found the s...
test-img

Scott

mysql/mariadb strict_trans_table mode. Log before enabling

I have an older legacy application running a old version of MariaDB(10.1). Before doing an upgrade i would like to make sure i "catch" all the insertion fails, auto-truncation etc. I've been...
test-img

Wel Rachid

mysql

mariadb

legacy-code

legacy-database

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs