Questions
Linux
Laravel
Mysql
Ubuntu
Git
Menu
HTML
CSS
JAVASCRIPT
SQL
PYTHON
PHP
BOOTSTRAP
JAVA
JQUERY
R
React
Kotlin
×
Linux
Laravel
Mysql
Ubuntu
Git
New posts in sql
Efficient rolling sum (window aggregate) in SAS
Jan 30, 2023
sql
sas
How to return multiple row value as a single row with multiple column using sql
Jan 30, 2023
sql
Query multiple columns on a given value in postgresql
Jan 30, 2023
sql
postgresql
Include zero in COUNT with GROUP BY in MySQL
Jan 30, 2023
mysql
sql
group-by
count
Relational table - is JSON recommended?
Jan 29, 2023
sql
json
rdbms
relational
EF6 returns wrong data from database
Jan 30, 2023
c#
sql
sql-server
entity-framework
SQL Order By with case when
Jan 30, 2023
sql
sql-order-by
case-when
How does Hibernate do row version check for Optimistic Locking before committing the transaction
Jan 27, 2023
sql
hibernate
race-condition
optimistic-locking
pessimistic-locking
Odd bug in SQL TRIM() function
Jan 29, 2023
sql
string
postgresql
select
trim
SQL Server : alter the Identity seed
Jan 27, 2023
sql
sql-server
ssms
MySQL how to get avg of values into specific range
Jan 29, 2023
mysql
sql
group-by
aggregate-functions
Conditionally replace single value per row in jsonb column
Jan 28, 2023
sql
postgresql
replace
sql-update
jsonb
How to select two different values from a table with different conditions in mysql?
Jan 29, 2023
mysql
sql
join
What query is faster: one update with multiple sets or multiple updates with one set?
Jan 29, 2023
mysql
sql
oracle
postgresql
SELECT TOP 2 MAX Value Group By SQL
Jan 29, 2023
sql
sql-server
tsql
group-by
sql-server-2014
How to group multiple columns into a single array or similar?
Jan 28, 2023
sql
json
postgresql
aggregate-functions
Django does not honor ON DELETE CASCADE
Jan 27, 2023
python
mysql
sql
django
mariadb
Why would BigQuery suddenly throw data format error
Jan 28, 2023
sql
firebase
google-bigquery
Multiple rows into single column
Jan 28, 2023
sql
sql-server
sql-server-2008
sql-server-2012
sql-server-2014
How to get Count for large tables?
Jan 28, 2023
mysql
sql
database
postgresql
performance
« Newer Entries
Older Entries »