Examples of programming questions in sql

SQL Server Profiler deprecation - Replacement?
SQL Unit Testing Stored Procedures
date after two weeks from current date in SQL
SQL: Count distinct values from one column based on multiple criteria in other columns
How to log query and its execution time of each query which runs on a db?
Convert geography to geometry SQL Server 2008R2
Replace every comma in a column with a dot
default value for switch in access 2007
SQL count how many times a value appears in multiple columns?
Using group by and having clause
Propel: Get Raw SQL from Query object?
Make DbDataReader start reading again from the beginning of the result set
How to retrieve same column twice with different conditions in same table?
MS SQL Server Last Inserted ID
To get MYSQL query execution time in Query
MySQL MyISAM how to perform a read without locking a table?
How to limit the maximum display length of a column in PostgreSQL
Using IF / ELSE to determine a SELECT INTO statement
How to use DataAdapter with SqlTransaction in C#?
Pivoting data in MS Access
SQL Server - Generate script without primary key
How to transpose mysql table rows into columns
How can I add leading zeros to dates in Oracle?
Copy rows and change 1 value?
SSRS Grey out Parameter based on result from other Parameter
List of tables used in an SQL Query
MySQL: Creating table with two foreign keys fails with "Duplicate key name" error
How to insert null value in Database through parameterized query
Cyrillic symbols in SQL code are not correctly after insert
sql select count of multiple relationships with left join
cakephp see the compiled SQL Query before execution
How to split a value into multiple rows on the newline char in PostgreSQL?
Using output to set a variable in a merge statement
List of distinct years between two dates
Alternative of NOT IN On MySQL
Get row with highest or lowest value from a GROUP BY
wildcard for single digit mysql
TSQL Error: A RETURN statement with a return value cannot be used in this context
PostgreSQL query is slow when using NOT IN
Why does referencing a SQLite rowid cause foreign key mismatch?
Inner join with like clause
Fastest way to insert 30 thousand rows in a temp table on SQL Server with C#
Is it practical to have back-end (database side) validation for everything?
LOAD DATA from CSV file where doublequote was used as the escape character
Oracle - View function body from a package
SQL Insert statement syntax
SSIS OLEDB destination with SQL command
SQL Server Merge - Getting matched records to another temp table
Finding out if a column is NOT NULL
How to split string into columns for a view?
SQL optimisation - Word count in string - Postgresql
How do you find the same weekday last year in SQL?
SQL: Convert an integer into a hex string?
MySQL SELECT + add a character after value
could not create a list of fields for the query
SQL - How to calculate percentage change/growth
How can I use LEFT & RIGHT Functions in SQL to get last 3 characters?
ORA-00903 invalid table name error when deleting rows from a table
Is it bad to omit semicolon in MySQL queries?
Mysql: Swap data for different rows
mysql slow count in join query
Why SUM(null) is not 0 in Oracle?
How to add a not null to an already existing column in SQL Server?
how to create XML schema from an existing database in SQL Server 2008
Cast string+ntext to nvarchar error
How to copy row from a table to another table if the entry is not exist in the new table in sql
Get the nearest longitude and latitude from MSSQL database table?
SQL Server 2005 Using CHARINDEX() To split a string
SQL LIKE operator not working for comma-separated lists
Correct way to select from two tables in SQL Server with no common field to join on
Using Alias In When Portion of a Case Statement in Oracle SQL
How to wrap my query output with single quotation
SELECT rows that are a multiple of x
Workaround for "null primitives" in JDBC PreparedStatement?
What does 'vw' mean in this SQL statement?
Why does PostgreSQL not return null values when the condition is <> true
mysql view super slow
Iterating over PyoDBC result without fetchall()
DBCC CHECKDB to check errors in SQL Server database
Oracle Update Column LTRIM and RTRIM
SQL Query Stuck in Statistics State
Finding the longest streak of wins
generate guid for every row in a column
Most efficient way to test SQL connection string availibility
Replacing a full ORM (JPA/Hibernate) by a lighter solution : Recommended patterns for load/save?
Try_Convert for SQL Server 2008 R2
How to select the first N rows of each group?
Bash script to insert values in MySQL
SQL Error: 1191 - Can't find FULLTEXT index matching the column list
Strange Error XML parsing: line 1, character 2038, illegal xml character
How I can remove all NewLine from a variable in SQL Server?
How to use DATEDIFF function with Eloquent?
How to join MySQL tables using a nullable column?
How do I escape multiple characters in an sql like string?
How to add JCheckBox in JTable?
How to sort time ( In AM / PM ) in SQL?
Maven ojdbc jar dependency error: package oracle.jdbc does not exist
Multiple Query results in single table
'invalid for creating a default constraint' error when trying to add a constraint to an existing table
SQL - using an alias in a where clause in a subquery
Ignoring null values in in a postgresql rank() window function
Why hibernate always call "update" statement after using "select" statement in MySQL?
Right join query not working
How to create UNIQUE constraint in SSMS 2012
Value of real type incorrectly compares
alter column from time with time zone to timestamp
A more concise way to format COUNT result with thousands separator?
Inserting records into a MySQL table using Java
Different value counts on same column
Using "TYPE = InnoDB" in MySQL throws exception
SQL Insert depending if a column exists
Selecting First and Last record from a table in SQL Server
How do we select top 20% and bottom 80% records in sql server
Why CREATE VIEW must be first statement in a batch?
Adding column to table & adding data right away to column in PostgreSQL
EntityFramework not updating column with default value
MySQL 'LIKE' query with spaces
Command.ExecuteScalar always return null while Stored Procedure in Management Studio runs fine
Nullable integer values from reader
Conditional update statement in Oracle
Joining different tables based on column value
finding products that customers bought together
SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
Doctrine and Symfony2: WHERE a.title LIKE $array
How to make sql query result to xml file
SQL Server : dynamic pivot over 5 columns
Dynamically Generating SQL Queries with Python and SQLite3
LIKE and NULL in WHERE clause in SQL
Can't create schema inside begin block
white circle in microsoft SQL server management studio 2012
How to connect user with a login cookie in PHP?
Postgres compare timestamp with long unix timestamp
Count of Columns in temp table in SQL Server
check date between two dates or NULL in sql
SQL Transaction uncommittable while using try..catch.. Why?
MySQL foreign key ON DELETE SET NULL check data types error
Stored procedure returns null as output parameter
Group Rails query into arrays by attribute
How to benchmark a SQL Server query using SQL Server
Postgres return a default value when a column doesn't exist
Find all duplicate records in SQL table with Entity Framework
postgresql generate sequence with no gap
Handle exceptions in entity framework 4
Using column name when using SqlDataReader.IsDBNull
change all synonyms to another database
H2 - DATEADD for complete day
SQL - UNION, priority on the first select statement when doing order by
Ignore duplicate rows in COUNT
Check multiple rows for value, return only row with MAX/MIN
MS SQL How to Update multiple rows with single value?
Getting the current date in SQL Server?
Oracle SQL comparing dates
Insufficient Privileges when creating tables in Oracle SQL Developer
Set Snapshot isolation is not reflecting
How to combine a column name into MySQL "LIKE" clause
How do I force Django to connect to Oracle using Service Name
Difference between .SQL and .DUMP files
Cant define SQL variable when using WITH statement
DataTable.Select string function in where clause
H2 database, insert by selecting results from CSVREAD
Database Deadlock in SELECT FOR UPDATE
Get total count of rows in pagination query
How do you leave comments in SQL Server 2008 R2 view with SSMS?
what is the differences between that line in oracle ERD?
Create index on create table
SQL select distinct but "keep first"?
CONCAT_WS() for SQL Server
Return all rows from one table, and match with a subset of rows from another table?
Plot tables and relationships from Postgresql tables
Boolean giving invalid datatype - Oracle
Return All Months & Years Between Date Range - SQL
How to read SQL Server COUNT from SqlDataReader
Searching between dates in SQL with JDBC?
Sql question marks in insert statement
Incorrect syntax near 'OFFSET'" modift sql comm 2012 to 2008
How to Insert Current date into oracle database from a java program?
Procedure or function has too many arguments specified" But It Doesn't
SQLite trim end characters from string
MySQL combine strings from many rows like SUM for int
How to LEFT JOIN in DB2 iseries with first row?
property.GetValue(this, null) leads to "Object does not match target type
JDBC - select where column is NULL
Add 2 weeks to a date SQL
How do I use 'Where In' in Dapper
MySQL alter table add column with primary key syntax error
How to store select statement result to table variable in sql server
limit vs exists vs count(*) vs count(id) in MySQL
Are left outer joins associative?
JOOQ & transactions
PHP SQL Order by date and id
Cannot call methods on char
Django filter queryset on "tuples" of values for multiple columns
How to calculate a MSSQL query execution time using python
MINUS Operator in oracle
Select Average of Top 25% of Values in SQL
Need week number of year in SSRS 2008
Parameterized dynamic sql query
DISTINCT with PARTITION BY vs. GROUPBY
must declare the scalar variable '@custid' using dbcontext.Database.SqlQuery?
Find which rows where foreign key constraint fail
What is the major difference between Varchar2 and char
Select between date range and specific time range
Two duplicate indexes with the same columns
Whats wrong with sp_rename with column?
How can I prevent SQL injection in PYTHON-DJANGO?
Oracle query for time difference in seconds
MySQL update join with limit
comparison of truncate vs delete in mysql/sqlserver
String matching in Peewee (SQL)
How to generate random boolean value in sql server 2008?
Conversion of one or more characters from XML to target collation impossible
simple query: not implemented by SQLite JDBC driver
Converting java.sql.Date & java.util.Date to org.joda.time.LocalDate
Select a row of first non-null values in a sparse table
Replace NonASCII Characters in MYSQL
Can DESCRIBE syntax be embedded in SELECT statement?
PostgreSQL 9.1 primary key autoincrement
Order by with a particular value on TOP
Mysql : How to run batch of sql scripts from a folder
Hex string to integer conversion in Amazon Redshift
SQL SUM values where 2 conditions are met
MySQL Distinct and LEFT JOIN returns duplicate
StDev() function returns Null when table contains only one row
oracle timestamp without seconds
Implementing RANK OVER SQL Clause in C# LINQ
MySQL for replace with wildcard
How can I update date of datetime field with mysql only?
Save Flag Enums in SQL Database and EF6. Is this possible?
Adding filter on the right side table on Left outer joins
MySQL Query to CSV
Sql insert if row does not exist
with(nolock) , (nolock) , nolock differences?
How do I create a temporary table from a type?
SQLite update query Android
How to Query to Find out if a Table has a CLUSTERED Primary Key
sqlalchemy join with sum and count of grouped rows
Many tables or rows, which one is more efficient in SQL?
Inserting with empty values in PostgreSQL causes error
Entity Framework 6: Code First Cascade delete
How to get first day of the week and last day of the week in sql server 2008?
SQLite How to find the most common occurrences of a value
PostgreSQL nested INSERTs / WITHs for foreign key insertions
Raw DB querying in Rails
SQL run from Excel cannot use a temporary table
SQL Server Reporting Studio report showing "ERROR#" or invalid data type error
How to create report textbox aggregate expression in SQL server reporting with multiple datasets
NullReferenceException trying to read connection string
PostgreSQL get last value in a comma separated list of values
How to display only date in GridView when pulling data from a DB? C#
Merge to update all target table columns