Jason Fried
BAN USER
Questions (1)
Comments (4)
Reputation 20
- 0of 0 votes
Answers(MYSQL question)
- Jason Fried in United States
I need to compare 2 columns in a table and give 3 things:
1. Count of rows checked.
2. Count of rows matching.
3. Count of rows different.
I've been able to get just rows matching using a join on itself, but I'm unsure how to get the others all at once. The importance of getting all of the information at the same time is because this is a very active table and the data changes with great frequency.| Report Duplicate | Flag | PURGE
Database
Page:
1
Comment hidden because of low score. Click to expand.
Comment hidden because of low score. Click to expand.
0
of 0 vote
Good catch, thnx.
- Jason Fried January 04, 2012Comment hidden because of low score. Click to expand.
0
of 0 vote
Great answer!
Thanks.
Comment hidden because of low score. Click to expand.
-1
of 3 vote
<SPAM>
- Jason Fried January 04, 2012Page:
1
CareerCup is the world's biggest and best source for software engineering interview preparation. See all our resources.
@Manan.
- Jason Fried January 12, 2012Can you pleas remove your solution?
Something went wrong, seeing as the question itself has been changed for some weird reason.