User Profile

Collapse

Profile Sidebar

Collapse
gcleffff
gcleffff
Last Activity: Feb 22 '08, 11:07 PM
Joined: Feb 19 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • gcleffff
    replied to Need Help On Multiple Max Values
    in SQL Server
    many thanks to you it worked im still a noob at querying can you give me some tips on where to learn more or what book do i need to be a master like you thanks a lot...
    See more | Go to post

      Leave a comment:

    • gcleffff
      started a topic Need Help On Multiple Max Values
      in SQL Server

      Need Help On Multiple Max Values

      i got a table like this

      TABLE:
      phonenum | crc | attempts | lastcalled
      1234 | sd | 5 | 2007-1-08
      1234 | ab | 8 | 2006-1-08
      2345 | sd | 1 | 2007-1-08
      2345 | sd | 5 | 2005-1-06

      i need to get the latest date (lastcalled) then the following fields that will return an output like this: it will extract the latest...
      See more | Go to post
      No activity results to display
      Show More
      Working...