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
Deleting a table in PostgreSQL without deleting an associated sequence
Sep 15, 2022
sql
postgresql
sequence
sequences
Database structure for voting system with up- and down votes
Sep 15, 2022
sql
database
schema
voting-system
SQL Server 2008 R2 HASHBYTES SHA2 returns null
May 02, 2021
sql
sql-server-2008
hash
Does mysql have the equivalent of Oracle's "analytic functions"?
Aug 18, 2022
mysql
sql
database
oracle
Setting column values as column names in the SQL query result
Aug 27, 2019
mysql
sql
pivot
Python SQLite how to get SQL string statement being executed
Sep 15, 2022
python
sql
sqlite
How to reuse a sub query in sql?
Nov 09, 2022
sql
sql-server
tsql
subquery
SQL Server : left join results in fewer rows than in left table
Sep 15, 2022
sql
sql-server
left-join
Python Peewee execute_sql() example
Sep 15, 2022
python
sql
database
peewee
convert rows to string in postgresql
Nov 27, 2019
sql
postgresql
postgresql-9.3
SQLite: Preventing Duplicate Rows
Sep 23, 2022
sql
database
sqlite
How to use MySQL like with order by exact match first
Sep 15, 2022
mysql
sql
Why is my t-sql left join not working?
Nov 16, 2022
sql
sql-server
Postgres append or set each elements(if not exists) of an array to an array column
Mar 09, 2022
sql
arrays
postgresql
Update or create nested jsonb value using single update command
Nov 09, 2022
sql
json
postgresql
SQL - improve NOT EXISTS query performance
Jul 21, 2022
sql
sql-server
performance
where-clause
not-exists
Weighted average in T-SQL (like Excel's SUMPRODUCT)
Nov 12, 2022
sql
sql-server
tsql
statistics
Multiple aggregate functions in one SQL query from the same table using different conditions
Aug 16, 2022
sql
sql-server
tsql
aggregate-functions
Ad hoc queries vs stored procedures vs Dynamic SQL [closed]
Sep 23, 2022
sql
stored-procedures
dynamic-sql
adhoc-queries
Select & Insert across multiple databases with MySQL
Sep 15, 2022
sql
mysql
data-migration
« Newer Entries
Older Entries »