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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. satishteradata

    Teradata SQL help needed

    HI I think we can get the required output with the below query using qualify select * from table_name qualify row_number() over(partition by ordernum,name,zip order by start_date asc,end_date desc)=1

Part and Inventory Search

Back
Top