Replicate Excel Quartile Function in Sql Server 2008 R2

Hi, does anyone know if there's a way to replicate Excel's Quartile Function in SQL Server 2008? Thanks.
Shino_skayAsked:
Who is Participating?
 
HainKurtSr. System AnalystCommented:
maybe you can use nTile(4)

select *, nTile(4) over (order by some_column) qTile
from mytable
0
 
Shino_skayAuthor Commented:
there is a long complicated sql replication for the excel's quartile function to be mimiced in sql server
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.