Explain Codes LogoExplain Codes Logo

Sql

Oracle SQL Developer - tables cannot be seen

sql
database-visibility
sql-developer
upgrade-issues

Order varchar string as numeric

sql
data-conversion
sql-indexing
database-performance

Mysql GROUP_CONCAT duplicates

sql
distinct
group_concat
performance-implications

Sqlite Like % and _

sql
pattern-matching
sql-queries
database-management

Sql Server IF EXISTS THEN 1 ELSE 2

sql
best-practices
performance
sql-queries

Create Table from View

sql
performance
best-practices
join

Cast syntax to convert a sum to float

sql
prompt-engineering
best-practices
performance

Postgresql return 0 if returned value is null

sql
null-value-handling
coalesce-function
sql-averages

Selecting rows where remainder (modulo) is 1 after division by 2?

sql
modulus-operator
sql-performance
sql-optimization

Sql query to determine that values in a column are unique

sql
data-type-discrepancies
uniqueness-detection
sql-queries

Sql query fetching data from multiple tables

sql
join
subqueries
performance

Order BY items must appear in the select list if SELECT DISTINCT is specified

sql
best-practices
sql-queries
database-management

How to select bottom most rows?

sql
performance
best-practices
sql-queries

Do indexes work with "IN" clause

sql
index-usage
query-optimization
performance-tuning

Sql Row_Number() function in Where Clause

sql
window-functions
subqueries
common-table-expressions

Can MySQL replace multiple characters?

sql
regexp
mysql-features
string-manipulation

Mysql combine two columns and add into a new column

sql
data-integrity
database-design
sql-queries

How to use DbContext.Database.SqlQuery<TElement>(sql, params) with stored procedure? EF Code First CTP5

sql
sql-exceptions
sql-query
stored-procedures

Sql to Entity Framework Count Group-By

sql
linq
groupby
performance

Modify table: How to change 'Allow Nulls' attribute from not null to allow null

sql
database-management
data-integrity
sql-syntax