Oracle SQL query: Retrieve latest values per group based on time
Fetch the row which has the Max value for a column
How to get the IPV4 address for an interface from /proc Is there a clean, simple way to get an IP address for a network interface from /proc, similar to the way I can get the MAC address for a network interface? Ideally I would just type cat /proc/&lt;foo&gt;/{interface_name} and get the IPv4 address.  I'd rather not run anything other than cat. How to align content of a div to the bottom Say I have the following CSS and HTML code:    #header {   height: 150px; } &lt;div id="header"&gt;   &lt;h1&gt;Header title&lt;/h1&gt;   Header content (one or multiple lines) &lt;/div&gt;     The header section is fixed height, but the header content may change.  I would like the content of the header to be vertically aligned to the bottom of the header section, so the last line of text "sticks" to the bottom of the header section.  So if there is only one line of text, it would be like:   ----------------------------- | Header title | | | | header content (resulting in one line) -----------------------------   And if there were three lines:   ----------------------------- | Header title | | header content (which is so | much stuff that it perfectly | spans over three lines) -----------------------------   How can this be done in CSS? Passing data between view controllers Draw Lewis structures like a book I want to draw a Lewis structure as in the picture. I tried to do with chemfig but does not perform the separation of the points and a minus in the superscript. Run VirtualBox in background, without a window? I was wondering if it's possible to run an Ubuntu virtual machine using VirtualBox in background, I mean, without any window open.  The idea is to connect via SSH to the Linux host, that would be running in background.  Has anyone ever done something like this? Is it possible? Why is the sum of the digits in a multiple of 9 also a multiple of 9? The sum of the digits in $9 k$ (where $k$ is an integer) is a multiple of $9$: for example   $$9\cdot 1=9$$ $$9\cdot 7=63 \qquad  \text{and } 6+3=9\cdot 1$$ $$9\cdot 11=99 \qquad \text{and }  9+9=9\cdot 2$$  But why? Why there is a delay between when a key is pressed and when it is accepted? Suppose we have $x^2+4x+3=0$  We differentiate both sides to get $2x+4=0$.  So $x=-2$  But $(-2)^2+4(-2)+3=0$   $4-8+3=-1$ is not equal to $0$.  Which tells that we cannot differentiate equalities. But in many proofs, like in integral calculus, differentiating both sides occurs. So, where is the fallacy? Is there a tag in HTML that will only display its content if JavaScript is enabled? I know &lt;noscript&gt; works the opposite way around, displaying its HTML content when JavaScript is turned off. But I would like to only display a form on a site if JavaScript is available, telling them why they can't use the form if they don't have it.  The only way I know how to do this is with the document.write(); method in a script tag, and it seems a bit messy for large amounts of HTML. Uk tourist visa - duration of stay My mother is given a UK tourist visa for 2 years with a duration of stay as 180 days. It is a c type multiple entry visa. Is this 180 days is the total stay she can take or is it duration of stay per visit.  Thanks in advance for your reply. I know that I can make certain blocks only placeable on a specified block, but what is the command to give an item that can only BREAK certain blocks? Do multi-use keys get discarded when finished with? As with many resident evil games, you sometimes needs to collect certain keys to open certain doors, and resident evil 7 has plenty of these around.  Some keys are clearly single use, and get left in the lock in which you use them. However, there are a number of keys that can be used on multiple doors. For example, the Scorpion Key.  I am concerned that I might end up carrying these around needlessly and using up valuable inventory space, so...  Do these multi-use keys get discarded when you use them on all the doors they apply to? Or do you get a warning saying the key is no longer needed? (like previous games are known to do) Is there a printable version of a reference manual for all TeX primitives? Noticing that Newtonian gravity and electrostatics are equivalent, is there also a relationship between the general relativity and electrodynamics? In classical mechanics, we had Newton's law of gravity $F \propto \frac{Mm}{r^2}$.  Because of this, all laws of classical electrostatics applied to classical gravity if we assumed that all charges attracted each other due to Coulomb's law being analogous.  We can "tweak" classical electrostatics to fit gravity.  In modern physics, does the reverse work?  Can we "tweak" General Relativity to accurately describe electrostatics or even electromagnetism? What does this red icon on my panel mean? This red icon.... It showed up after I upgraded to Ubuntu 12.04LTS; I can't figure out how to ditch it. It seems to be a notification thing.  I am at a loss.  The icon is this one:      I clicked it and read this:     An error occurred, please run Package Manager from the right-click menu or apt-get in a terminal to see what is wrong. The error message was:  'Error: BrokenCount&gt;0'.        This usually means that your installed packages have unmet dependencies. How do I resolve a recurrence relation when the characteristic equation has fewer roots than terms? I know how to solve "simple" recurrence relations. For instance, say you have:  $$c_0 = 20$$ $$c_1 = 30$$ $$c_n = 3 c_{n-1} - 2 c_{n-2}$$  We can write the characteristic equation as:  $$3x^{n-1} - 2x^{n-2} = x^n$$  Solving this with $n=2$, we get $x = 1$ or $x = 2$. This lets us write the relation $c_n = \alpha_1 1^n + \alpha_2 2^n$, and we can solve for $\alpha_1$ and $\alpha_2$ with the initial states $c_0$ and $c_1$.  However, this depends on the fact that $3x^{n-1} - 2x^{n-2} = x^n$ has two roots.  Now, I'm stuck on another problem where the characteristic equation has fewer roots than terms.  Say I have this recurrence relation instead:  $$a_0 = 0$$ $$a_1 = 2$$ $$a_2 = −1$$ $$a_n = 9a_{n-1} - 15a_{n-2} - 25a_{n-3}$$  The characteristic equation would be:  $$9x^{n-1} - 15x^{n-2} - 25x^{n-3} = x^n$$  However, solving with $n=3$, we only get two roots: $x=-1$ or $x=5$. There are not enough roots to write a relation in the form of $a_n = \alpha_1 r_1^n + \alpha_2r_2^n + \alpha_3r_3^n$. How do I proceed? Is there a CSS parent selector? How to express a polar coordinate for a macro that only accepts space-separated values? \psElectricfield only accepts a coordinate in space-separated values as follows. For example, a charge of -0.1 unit at (-1,0) is written as [-0.1 -1 0]. I have attempted to write in PS notation but it still does not work.  \documentclass{article} \pagestyle{empty}  \usepackage{pst-electricfield,multido} \def\M{2}  \begin{document} \multido{\i=0+30}{12}{% \begin{pspicture*}(-\M,-\M)(\M,\M)     \psElectricfield     [         Q={[-0.1 -1 0][-0.1 1 0][0.1 !\i sin 2 mul \i cos 2 mul]}     ] \end{pspicture*}\newpage} \end{document}   How to express  a polar coordinate for a macro that only accepts space-separated values? When the external resistor increases in temperature, why is the calculated value for internal resistance higher? Say we had a circuit with a cell (with internal resistance)and an external resistor of $10 \Omega$ as shown:  The $10\Omega$ resistor then increases in temperature, leading to an increase in resistance in this resistor. My thinking was that since $10 \Omega$ resistor now has a value higher than $10\Omega$, more voltage drops across this resistor. Since your emf is constant, less voltage must drop across the internal resistor. Less voltage drop means less resistance. Where is the flaw in my logic? Let's say I have the following class X where I want to return access to an internal member:  class Z {     // details };  class X {     std::vector&lt;Z&gt; vecZ;  public:     Z&amp; Z(size_t index)     {         // massive amounts of code for validating index          Z&amp; ret = vecZ[index];          // even more code for determining that the Z instance         // at index is *exactly* the right sort of Z (a process         // which involves calculating leap years in which         // religious holidays fall on Tuesdays for         // the next thousand years or so)          return ret;     }     const Z&amp; Z(size_t index) const     {         // identical to non-const X::Z(), except printed in         // a lighter shade of gray since         // we're running low on toner by this point     } };   The two member functions X::Z() and X::Z() const have identical code inside the braces.  This is duplicate code and can cause maintenance problems for long functions with complex logic.    Is there a way to avoid this code duplication?