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 bkrike 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: *

  • Users: pendarric
  • Content: Threads
  • Order by date
  1. pendarric

    distinct by a column

    Lets say we have a table with an id and a date I want to find the most recent date for each id. eg 62997 2000-12-16 63702 2000-02-02 100004 2001-03-14 62997 2000-02-22 100008 2000-03-26 should output 62997 2000-12-16 63702 2000-02-02 100004 2001-03-14 100008 2000-03-26 This is easy...
  2. pendarric

    cursors

    I am having some trouble with an SQL query the data would look something like thie id attribute 1 blue 2 yellow 1 black 3 white 4 green 2 blue 5 green 2 brown 1 yellow 4 white the output needs to be like this. id attribute 1 blue,black,yellow 2 yellow, blue, brown 3 white 4 green 5 green,white...

Part and Inventory Search

Back
Top