Explain Codes LogoExplain Codes Logo

Sql

How do I ALTER a PostgreSQL table and make a column unique?

sql
unique-constraint
postgresql
database-design

Get records of current month

sql
date-format
unix-timestamp
database-performance

New line in Sql Query

sql
new-line-character
sql-query
database-environments

Sql DELETE with JOIN another table for WHERE condition

sql
join
delete
subqueries

Sql Update query with group by clause

sql
subquery
update-query
group-by

How can I prevent SQL injection in PHP?

sql
sql-injection
prepared-statements
php-security

Delete all Duplicate Rows except for One in MySQL?

sql
delete-duplicates
mysql-error-1093
data-integrity

How to implement a many-to-many relationship in PostgreSQL?

sql
indexing
foreign-keys
data-integrity

Applying the MIN aggregate function to a BIT field

sql
prompt-engineering
best-practices
performance

How to compare strings in SQL ignoring case?

sql
case-insensitive-search
sql-indexes
collation-settings

'if' in 'SELECT' statement - How to Manipulate Output Based on Column Values

sql
case
ifnull
null-handling

Sql Server 2008- Get table constraints

sql
constraints
foreign-keys
data-integrity

How to reset AUTO_INCREMENT in MySQL

sql
auto-increment
data-integrity
phpmyadmin

Syntax of for-loop in SQL Server

sql
for-loop
offset-fetch
performance

Use string contains function in oracle SQL query

sql
pattern-matching
contains
regexp

Convert Xml to Table SQL Server

sql
xml
openxml
xquery

What does Include() do in LINQ?

sql
include
eager-loading
lazy-loading

Declare a variable in a PostgreSQL query

sql
session-variables
plpgsql
temporary-tables

Find records with a date field in the last 24 hours

sql
date-functions
performance
timezones

Sql Server: Get data for only the past year

sql
date-filtering
performance
dynamic-queries
explain.codes / Sql