date range

Bangalore, India

#1 Apr 5, 2012

num eff_d expr_d
1 01-01-2011 04-01-2011
1 02-01-2011 05-01-2011

dates are in dd-mm-yyyy format
eff_d in 2nd row is less than expr_d in 1st row
how to find out such records in a table?

Tell me when this thread is updated:

Subscribe Now Add to my Tracker

Add your comments below

Characters left: 4000

Please note by submitting this form you acknowledge that you have read the Terms of Service and the comment you are posting is in compliance with such terms. Be polite. Inappropriate posts may be removed by the moderator. Send us your feedback.

Teradata Discussions

Title Updated Last By Comments
How can the Semantic Views be tuned in Teradata? Oct 13 SachitSachdev 1
display difference between total salary of dept... (Dec '14) May '16 Raghu_349 2
teradata sql (Dec '14) Dec '14 yuvraj 1
transpoing rows into columns in view (Oct '13) Oct '13 Arun 1
News RIM Estimates Fall Below Consensus and 4 Stock ... (Dec '12) Dec '12 Rrainerr 4
Teradata bteq script(update statement) (Jul '12) Jul '12 bharath 1
teradata (Aug '11) Aug '11 madhu_teradata 1
More from around the web