Explain Codes LogoExplain Codes Logo

Sql

Create a Superuser in postgres

sql
database-management
postgresql
superuser-creation

How to get/generate the create statement for an existing hive table?

sql
hive
ddl
database-management

Error related to only_full_group_by when executing a query in MySql

sql
sql-standards
group-by
mysql-5.7

Select Top 1 field and assign to local variable

sql
prompt-engineering
best-practices
error-handling

Find records from one table which don't exist in another

sql
performance
best-practices
database

Error in SQL script: Only one statement is allowed per batch

sql
best-practices
tools
project-settings

Selecting data from two different servers in SQL Server

sql
linked-servers
cross-server-communication
sql-server

Mysql: difference between two timestamps in seconds?

sql
timestampdiff
unix_timestamp
datetime

How do I restore a dump file from mysqldump?

sql
mysql
database
backup

Size of VARBINARY field in SQL Server 2005

sql
data-length
varbinary
sql-server

Sql Select Only Rows with Max Value on a Column

sql
window-functions
sql-performance
database-optimization

Mysql add days to a date

sql
date-manipulation
mysql-functions
sql-queries

Get the records of last month in SQL server

sql
performance
best-practices
date-functions

Simulating group_concat MySQL function in Microsoft SQL Server 2005?

sql
join
performance
best-practices

Sql Query - Using Order By in UNION

sql
join
best-practices
dataframe

Sql Query to list all views in an SQL Server 2005 database

sql
join
performance
best-practices

Get SQL query count during a Django shell session

sql
database-performance
django-extensions
query-tracking

How many rows in a database are TOO MANY?

sql
performance-optimization
database-optimization
indexing

Can I create a named default constraint in an add column statement in SQL Server?

sql
default-constraints
sql-server
database-design

The object 'DF__*' is dependent on column '*' - Changing int to double

sql
database-operations
error-handling
data-types