New posts in sql

Window function for is_unique?

Return a value if no record is found

Selecting distinct combinations

Why Stored Procedure is faster than Query

SQL Server 2005 and temporary table scope

MAX vs Top 1 - which is better?

SQL Database Design Best Practice (Addresses)

With Entity Framework is it better to use .First() or .Take(1) for "TOP 1"?

If else on WHERE clause

How can I declare a Boolean parameter in SQL statement?

How to export data from Excel spreadsheet to Sql Server 2008 table

PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: ;

MySQL Group By and Sum total value of other column

SQL: How To Select Earliest Row

Get AVG ignoring Null or Zero values

Get the list of stored procedures created and / or modified on a particular date?

Hadoop/Hive : Loading data from .csv on a local machine

How to add "IF NOT EXISTS" to create trigger statement

What is the best way to convert an int or null to boolean value in an SQL query?

Index for multiple columns in ActiveRecord