I have the following table:  Column 1 | Column 2 | Column 3 1        | A        |       70 2        | A        |       32 3        | A        |        4 4        | B        |       44 5        | B        |       98 6        | B        |       10   Column 1 contains the ID number of the row, Column 2 a string (which repeats across other rows), and Column 3 a number. I want to keep one entry per Column 2 string, but also the one with the highest number in Column 3. So the resulting table I am interested to get is:  Column 1 | Column 2 | Column 3 1        | A        |       70 5        | B        |       98   Any ideas?  Thanks.
I have several spreadsheets with information I need to consolidate, each with different (and sometimes overlapping) portions of the final data set I'm hoping to create. Typically, combining spreadsheets with similar data is easy to do by dumping all the data into one sheet and using Remove Duplicates. However, I want to make sure that the line items which are left represent the latest version of the duplicates.  I will be importing the following data from each spreadsheet:   A unique identifier field, (UID) which identifies the subject of the line item and will be used to spot duplicates between the input sheets. A status field, (STATUS) which will have information about the item called out in the unique identifier field. A date field, (DATE) which will contain the date the imported data was originally written.   What I need is for my output to contain only one line item for each UID, and have data from the STATUS field which matches the most recent DATE for that UID from the input sheets.  What is the easiest way to do this in Excel?
How to handle trigger recursion I have two objects A(parent) and B(child) related by a lookup relationship. I  need to update records in object A using data loader. There is an after update trigger on object A which updates some fields on related records of object B. On object B as well there is an after update trigger which updates a field on parent object A. How can i handle recursion. How can I prove $n - 2\sqrt{n} = \Theta(n)$ Get most common value for each value of another column in SQL I have a table like this:   Column  | Type | Modifiers  ---------+------+-----------  country | text |   food_id | int  |   eaten   | date |    And for each country, I want to get the food that is eaten most often.  The best I can think of (I'm using postgres) is:  CREATE TEMP TABLE counts AS     SELECT country, food_id, count(*) as count FROM munch GROUP BY country, food_id;  CREATE TEMP TABLE max_counts AS     SELECT country, max(count) as max_count FROM counts GROUP BY country;  SELECT country, max(food_id) FROM counts     WHERE (country, count) IN (SELECT * from max_counts) GROUP BY country;   In that last statement, the GROUP BY and max() are needed to break ties, where two different foods have the same count.  This seems like a lot of work for something conceptually simple.  Is there a more straight forward way to do it? Eclipse: I turned on hidden characters now I can't turn off Showing that $f:(0,2\pi]\to S^1$ is not a homeomorphism I want to show that $f:(0,2\pi]\to S^1$ defined by $t\to (\sin t, \cos t)$ is not a homeomorphism. I will do this by showing that its inverse is not continuous.    The inverse is defined by $(\sin t, \cos t)\to t$. So at $(0,1)$ we want to have $\lvert 2(1-\cos t)\rvert &lt;\delta \Rightarrow \lvert t-2\pi\rvert&lt;\epsilon$ for any $\epsilon$. If we take $\epsilon=\pi/2$, no matter how close $\cos t$ and $1$ are there will always be $t$'s close to $0$. So $f^{-1}$ is not continuous.  What do you think? Are there any mistakes? I want to select questions that are only tagged as SQL, SQLServer, SQLSever 2008. I am not interested in questions that have anything more than these tags. How do i select such questions only ? If my Schengen visa starts on the day of arrival which is one day ahead of departure, would they let me get into the plane? I have a question, I applied for the Schengen visa through Germany, on the form they ask me when I'd arriving (to Germany) and when I'd returning. they take this exact date as the visa period.  I wondering if they would let me get into the plane, even though my flight it a day before the arrival.  Let get the real deal; let say this:  My visa is valid from 02/12/2014 to 02/02/2015. But, my flight is scheduled to be departing on 01/12/2014, but entering Germany 02/12/2014. the flight duration is almost 9hours and there is 7hours difference between Germany and the departing flight country. I have a set of polygons representing administrative districts.  The districts were digitized by hand, and there are small spaces (slivers) between polygons where the polygons should be touching. How can I have the polygons snap together, removing the spaces? Is it possible to sort non-stackable items in minecraft? are super sweet.  But, I have a skeleton farm, and am getting tons of non-stackable drops.  Since armor can be smelted into iron/gold, I'd like to smelt those drops in a furnace, and burn bows in a furnace.  And trash all leather armor.  Is there a way to sort out these non-stackable items in vanilla survival? I have an Asus R500VD laptop which came with the preinstalled Windows 8. As actually this computer will be used by my grandmother (and she's only using win 7) I'd like to downgrade it.  Thanks to other thread here, I was able to successfully boot computer from Windows 7 USB stick, but unfortunately during install I got a message:  A required CD/DVD drive device driver is missing. (...)   and I can't get pass it... This is what I've done:   I've downloaded all drivers from Asus Website (), unzip and copied to visible location for windows 7 installation - I've picked each one of them, none has helped. As I belive it's some kind of problem with SATA/RAID/AHCI drivers I went to Intel site and downloaded various "Intel Rapid Storage Technology" drivers - a lot of them were recognized by win7, but none of them helped.   Does anyone have an idea what can I do next? Any help would be really appreciated. Which standard objects don't support triggers? Will i be granted ESTA after getting rejected thrice on different nationality? I had applied for B1/B2 on my previous nationality but it got rejected Thrice.  I had planned on visiting my mother as she lives there. my last refusal was 3 years back. Now i have gained an European nationality and I am thinking of applying for ESTA so I can visit my mother. I have doubts if it will be accepted because I'll have to disclose about my previous refusals.  What should I do? because if I don't disclose my previous refusals I fear I might be rejected permanently. Move Lifejacket and Lifeboat to Answer Badges section in Help Center The new blog post  mentions the new badges  and  are answer badges, but they are listed on the  under Question Badges:    Since you earn these primarily by posting an answer (you're not required to do anything about the question, though editing it will probably help), they definitely belong to the Answer Badges. Why doesn't Neo teleport at random? Is “of ” necessary in “all of ”? Listen to all your fans   Name all the states   vs      Listen to all of  your fans   Name all of  the states   What part of language is of  in these examples? Is it necessary or optional, correct or incorrect? What is the difference between "I've been to China" and "I've gone to China"? Beginner Physics Resources? I'm interested in learning physics. I do realize that the subject is large and that it would be easier if I had a specific area of interest. However, I do not. I suppose I want to learn about the fundamentals of it all; the axioms that combine all physics fields. Or, in other words, a high school physics class.   Specifically, a book or series of videos would be helpful. I looked over MIT and unfortunately the material wasn't for me. I don't mean to be "picky" so I am not completely ruling out any resource just yet.   Thanks in advance. Feed can show entries for deleted posts, which viewing them fails That is, what are some good examples of vector spaces which are inner product spaces but in which not every Cauchy sequence converges? In basic chemistry, we are taught that an atom has roughly the same number of neutrons and number of protons, this doesn't seems to hold for larger atoms, but it is always roughly proportional (i.e. you seldom find an atom with 100 protons but 1 neutron, that just does not happen). Why is that?