Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by joedsilva

  1. joedsilva

    ODBC Error TERASSO

    I hope ICU, CLI and GSS packages are also installed ...
  2. joedsilva

    Teradata SQL Analyser display problem

    I have seen this happening when there's a comment on top of the select ... ie something like this .. -- my comment SELECT col1, col2 from mytable ;
  3. joedsilva

    Getting Recent 3 dates

    Actually it can be also written as Select name , product , date_of_sell From YOUR_TABLE QUALIFY rank() Over (Partition By name, product Order By date_of_sell) <= 3 ;
  4. joedsilva

    getting distinct values of a column in a partition query

    how about something like this SELECT T.STOREID, T.DEALERCD, T.DEALERNAME, T.DEALERPERMIT ,SUM(CASE WHEN T.PREVDEALERCD IS NULL OR T.PREVDEALERCD <> T.DEALERCD THEN 1 ELSE 0 END) OVER(PARTITION BY STOREID) FROM ( SELECT S.STOREID, S.DEALERCD, S.DEALERNAME, S.DEALERPERMIT ,MAX(DEALERCD)...
See more

Part and Inventory Search

Back
Top