This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Percentage disc function window.

SQL SERVER – Introduction to PERCENTILE_DISC() – Analytic Functions Introduced in SQL Server 2012

November 22, 2011
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts

An introduction to PERCENTILE_DISC, the SQL Server 2012 analytic function that returns an actual value from your data at a given percentile.

Read More
SQL query results showing median contigencies.

SQL SERVER – Puzzle to Win Print Book – Explain Value of PERCENTILE_CONT() Using Simple Example

November 21, 2011
Pinal Dave
SQL Puzzle
SQL Function, SQL Scripts

Win a print book: explain the value of PERCENTILE_CONT with a simple example, and learn this SQL Server 2012 function even on an earlier version.

Read More
SalesOrderDetail Report Showing Two Records.

SQL SERVER – Introduction to PERCENTILE_CONT() – Analytic Functions Introduced in SQL Server 2012

November 20, 2011
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts

An introduction to PERCENTILE_CONT, the SQL Server 2012 analytic function that finds a percentile on a continuous distribution, much like a median.

Read More
Rank calculation tool window.

SQL SERVER – Introduction to PERCENT_RANK() – Analytic Functions Introduced in SQL Server 2012

November 18, 2011
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts

An introduction to PERCENT_RANK, a SQL Server 2012 analytic function that returns the relative standing of a value in a result set, shown next to RANK.

Read More
Pasta strands arranged along a drying fan, with neighboring strands and a clear group gap

The Previous Row Before LAG Existed: A ROW_NUMBER Self-Join

November 17, 2011
Pinal Dave
SQL Tips and Tricks
Database, SQL Scripts, SQL Server

Before LAG, we numbered rows and joined each one to its neighbor. Here is how that pattern works, where ties and NULLs bite, and how LAG compares.

Read More
The red arrow indicates the use of the LEAD and LAG window functions.

SQL SERVER – Puzzle to Win Print Book – Write T-SQL Self Join Without Using LEAD and LAG

November 16, 2011
Pinal Dave
SQL Puzzle
SQL Function, SQL Scripts

Win a print book: write a T-SQL self join that simulates LEAD and LAG, so you can learn a SQL Server 2012 feature even on an earlier version.

Read More
The red arrow indicates the use of the LEAD and LAG window functions.

SQL SERVER – Introduction to LEAD and LAG – Analytic Functions Introduced in SQL Server 2012

November 15, 2011
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts

An introduction to LEAD and LAG in SQL Server 2012: read a value from the next or previous row without a self-join, with an AdventureWorks example.

Read More
Previous 1 … 212 213 214 215 216 217 218 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com