Is this the most efficient way...?

Linear Mode

Is this the most efficient way...?

~~Calgon~~
Banned

Posts: 6,129
Threads: 36
Joined: Jan 2009

#5

18.12.2011, 02:59

Quote:

Originally Posted by RealCop228

Посмотреть сообщение

Wouldn't the second query there be better?

Код:

SELECT email FROM users GROUP BY email HAVING ( COUNT(email) = 1 )

And thanks for the tip, I always wondered about that!

That only checks if there's 1 result, mine checks if there's 1 or more.

Find

Reply

« Next Oldest | Next Newest »

Messages In This Thread

Is this the most efficient way...? - by Scenario - 18.12.2011, 02:39

Re: Is this the most efficient way...? - by [HiC]TheKiller - 18.12.2011, 02:45

Re: Is this the most efficient way...? - by Calgon - 18.12.2011, 02:47

Re: Is this the most efficient way...? - by Scenario - 18.12.2011, 02:54

Re: Is this the most efficient way...? - by Calgon - 18.12.2011, 02:59

Re: Is this the most efficient way...? - by Scenario - 18.12.2011, 03:01

Re: Is this the most efficient way...? - by Calgon - 18.12.2011, 03:04

Re: Is this the most efficient way...? - by Scenario - 18.12.2011, 03:06

Re: Is this the most efficient way...? - by Lorenc_ - 18.12.2011, 03:06

Re: Is this the most efficient way...? - by jamesbond007 - 18.12.2011, 03:18

View a Printable Version

Forum Jump:

Users browsing this thread: 1 Guest(s)