Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql

How do I prevent people from running SELECT * on Snowflake tables?

Correlated subquery in a select statement with group by

SQL table for friends, mutual friends, friends friends etc

sql

Correct model for a database with a table for each user

EAV vs Serialized Object vs SQL with Xpath?

JPA Query using native query returns null instead of list of entities

BULK INSERT with two row terminators

Postgres JSONB query about nested/recursive elements

sql json postgresql

SQL Server XML - embedding a dataset within an existing node

sql sql-server xml

ANDROID SQLITE: How to retrieve primary key of a certain row [duplicate]

java android sql database sqlite

Having trouble understanding how running aggregate works

sql sql-server

Doctrine NOT EXIST condition with ManyToMany relation

sql symfony doctrine-orm

How to concatenate strings from multiple rows?

sql oracle-database

Index not used in Postgresql read-replica. Why?

SQL to show 1 for unique and 0 for reapeat

sql sql-server

How to get difference between two dates in Oracle and show it as ' x years y month z days'

sql oracle-database date

How can Delete be both a DDL and a DML statement

sql sql-server t-sql ddl dml

SUM values in SQL starting from a specific point in another table

Performance of primary key selection

sql sql-server-2008

How to update varbinary(max) column with path stored in varchar column?