Technical Article

Find Nth Max-Min Record - The Efficient Way!

It is quite often that we need to find Nth (5th or 8th or 10th) maximum or minimum number of record from the record set. The solution is different in MS SQL than in Oracle because we have RowNum in Oracle. Some time ago I got the same problem with a massive table of more […]

You rated this post out of 5. Change rating

2005-07-22 (first published: )

1,030 reads

Blogs

Removing a PowerShell Array Element–#SQLNewBlogger

By

I saw an article on this and realized I had no idea how to...

PostgreSQL Backup Failure

By

In this blog post I wrote a tip about fixing the PostgreSQL backup failure...

Dynamic Data Masking – SQL Server

By

Use Dynamic Data Masking to protect your data The post Dynamic Data Masking – SQL...

Read the latest Blogs

Forums

txt file Pipe

By juliava

Hello, I need to put data from table to txt file as pipe on...

Case statement to insert a new line in query output??

By jbalbo

Hi I need to insert a new line of my output when a condition...

Database Mail to work on Azure VM

By terry999

Trying to get Database mail working sending via  outlook.office365.com or smtp.office365.com port 587 using ...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers