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
Simple SQL Lite table/import question
Nov 05, 2022
sql
sqlite
sqlite3-ruby
Reordering an ordered list
Nov 02, 2022
sql
database-design
how to best organize the Inner Joins in (select) statement
May 01, 2018
sql
SELECT min and max value from a part of a table in MySQL
May 04, 2022
sql
mysql
max
min
Oracle: Indexing a subset of rows of a table
Feb 02, 2020
sql
database
oracle
indexing
how to select last 12 months name and year without using tables using sql query?
Sep 01, 2022
sql
sql-server
Initialising a pl/sql record type
Nov 16, 2022
sql
oracle
plsql
oracle10g
Concat two table columns and update one with result
Oct 26, 2022
sql
merge
concatenation
Is this a 1NF failure?
Jul 20, 2022
php
mysql
sql
database
normalization
how find "holes" in auto_increment column?
Dec 10, 2021
mysql
sql
gaps-and-islands
LIMIT offset or OFFSET in an UPDATE SQL query
Feb 15, 2018
mysql
sql
limit
offset
How to properly add brackets to SQL queries with 'or' and 'and' clauses by using Arel?
May 03, 2022
sql
ruby-on-rails
ruby
ruby-on-rails-3
arel
Postgresql select between month range
Oct 28, 2022
sql
postgresql
date
select
date-range
Store a PHP array in a single SQL cell
May 09, 2022
php
mysql
sql
arrays
SQL select elements where sum of field is less than N
Oct 30, 2022
sql
sqlite
postgresql
aggregate-functions
sql-limit
how to make sure a record is always at the top in a given resultset in mysql?
May 13, 2022
mysql
sql
sql-order-by
Transpose rows and columns (a.k.a. pivot) only with a minimum COUNT()?
Nov 19, 2022
sql
postgresql
pivot
crosstab
java sql insert
Oct 28, 2018
sql
Using decode to check for negative and positive values
Aug 24, 2022
sql
MySQL - SUM of a group of time differences
Apr 30, 2022
mysql
sql
aggregate-functions
« Newer Entries
Older Entries »