Sample Data

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.

Sample Data

Rate Topic

Display Mode

Topic Options

Author

Message

Schmacker

Posted 9/3/2008 10:20:37 AM

Forum Newbie

Group: Forum Members
Last Login: 9/3/2008 3:14:41 PM
Posts: 2, Visits: 31

I have a table that has 3 field in its PI (FLDA, FLDB and FLDC) FLDC is a date. There is over three years of dates in the table. I would like to see a sample of 10 rows from each of the dates in the table. (I'm actually pulling the data to build a test bed). Is this possible via one of the Teradata Utilities, or via some other ingenious magic?

Thanks,
Bob

Post #12812

shiyamala

Posted 9/5/2008 4:15:49 PM

Junior Member

Group: Forum Members
Last Login: 11/12/2008 12:15:47 PM
Posts: 13, Visits: 29

Try the below query:

SEL

flda

,fldb

,fldc

,RANK(flda,fldb,fldc)

FROM database.table

qualify (flda,fldb,fldc) < 11

group by fldc

Thanks,
Shiyamala

Post #12834

« 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 10:41pm