Results 1 to 2 of 2

Thread: [RESOLVED] Query Compare if the value of a field is doubled

  1. Nov 15th, 2009, 01:02 PM #1
    killer7k
    killer7k is offline

    Thread Starter
    Fanatic Member
    Join Date
    Jul 2007
    Posts
    530

    Resolved [RESOLVED] Query Compare if the value of a field is doubled

    problem solved
    i did forgot the distinct function
    Last edited by killer7k; Nov 15th, 2009 at 01:55 PM.
    Reply With Quote Reply With Quote
  2. Nov 15th, 2009, 07:32 PM #2
    dee-u
    dee-u is offline
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: [RESOLVED] Query Compare if the value of a field is doubled

    You need not have edited your post so that other members could have seen what the problem is and apply whatever your solution is.

    BTW, using GROUP BY is more optimized than using DISTINCT since distinct will still load all the records and just remove the duplicates while GROUP BY is not.
    Regards,

    ™

    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width