Sql

How do you manually execute SQL commands in Ruby On Rails using NuoDB

rails-activerecord

database-connections

How to use a LIKE with a JOIN in SQL?

Update records in table from CTE

Sql query to find record with ID not in another table

Mysql's now() +1 day

date-arithmetic

mysql-functions

sql-best-practices

Fastest check if row exists in PostgreSQL

transaction-control

performance-optimization

How do I obtain raw SQL from a query builder?

Add a summary row with totals

prompt-engineering

Mysql pivot row into dynamic number of columns

prepared-statements

Questions every good Database/SQL developer should be able to answer

Store select query's output in one array in postgres

array-constructor

database-optimization

Mysql syntax for Join Update

What is the meaning of the prefix N in T-SQL statements and when should I use it?

t-sql-best-practices

Sql WHERE condition is not equal to?

Datetime group by date and hour

Adding named foreign key constraints in a SQL Create statement

schema-evolution

foreign-key-constraints

Select info from table where row has max date

window-functions

sql-performance

How to order by with union in SQL?

'like ('%this%' OR '%that%') and something=else' not working

pattern-matching

Show the current username in MySQL?

database-connection

security-best-practices

explain.codes / Sql