Mode Function

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Mode Function

Rate Topic

Display Mode

Topic Options

Author

Message

Siinis

Posted 5/14/2008 10:18:38 AM

Forum Newbie

Group: Forum Members
Last Login: 10/7/2008 2:56:19 PM
Posts: 3, Visits: 13

I am searching for a Mode aggregate function.

the mode is the value that occurs the most frequently in a data set

Post #11435

dnoeth

Posted 5/14/2008 12:31:43 PM

Supreme Being

Group: Forum Members
Last Login: Today @ 7:20:23 AM
Posts: 533, Visits: 282

Hi Siinis,

SELECT col
FROM tab
GROUP BY 1
QUALIFY
RANK() OVER (ORDER BY COUNT(*) DESC) = 1

Dieter

Post #11436

Siinis

Posted 5/15/2008 10:07:38 AM

Forum Newbie

Group: Forum Members
Last Login: 10/7/2008 2:56:19 PM
Posts: 3, Visits: 13

Thank you very much. I had come up with something similar but yours is cleaner.

Post #11450

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 2 ( 2 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 4:35pm