Query to find hierarchical relationship between objects
hierarchical retreival of records in postgresql
How can I create an executable JAR with dependencies using Maven? Find the value of $\sin\frac{2\pi}{7}+\sin\frac{4\pi}{7}+\sin\frac{8\pi}{7}$ What is the difference between $* and $@? How to check if a column exists in a SQL Server table? How do I sort a MySQL table by two columns? What I want are articles sorted by highest ratings first, then most recent date.  As an example, this would be a sample output (left # is the rating, then the article title, then the article date)  +================+=============================+==============+ | article_rating | article                     | article_time | +================+=============================+==============+ | 50             | This article rocks          | Feb 4, 2009  | +----------------+-----------------------------+--------------+ | 35             | This article is pretty good | Feb 1, 2009  | +----------------+-----------------------------+--------------+ | 5              | This Article isn't so hot   | Jan 25, 2009 | +================+=============================+==============+  The relevant SQL I'm using is: ORDER BY article_rating, article_time DESC  I can sort by one or the other, but not both. How do we prove that $\lfloor0.999\cdots\rfloor = \lfloor 1 \rfloor$? Are the floor functions of $0.999\cdots$ and 1 equal?  It is true that $0.999\cdots=1$ but how does one justifies the integer part of $0.999\cdots$ being 1 , where it is not, or alternatively without using $0.999\cdots=1$ how can we show that  $\lfloor0.999\cdots\rfloor = \lfloor 1 \rfloor$ ? I tried to choose a answer for a question on SA and someone immediately answered with the correct response. I try to click the check box and it says wait 2 min. I keep clicking until it changes from 2 min to 1 min. I wait 60 seconds on my watch and click again and it says please wait 59 seconds.  The 2 minute mark should have said 3 and the 1 minute mark was really 2.  It seems that this has , which is a lot more inconvenient than 59 seconds. At the moment the most frustrating part of my brewday is getting the cold wort into the fermenter. Here is my process. I have a 20 litre saucepan that i use as a kettle that does not have a tap. At flame out I add my immerseion chiller that is plumbed into my kitchen sink tap. When I have reached temperature I remove the chiller and whirlpool and leave it to rest to 30 minutes. I am use a siphon to rack directly into the plastic bucket fermenter.  The problem is that the siphon always gets clogged with the hops after i have only transfered about 20% of the wort. I have also tried carefully pouring the wort through a seive, but this sort of depfeats the point of the whirlpool and also the seive got blocked with hops as well. All in all i end up wasting a lot of the wort because i am afraid of getting a lot trub in the fermenter.  What are the best processes to use with my current equpment to get the wort into the fermenter? I'm reading a lot of documentation on sed, and am still stumped on my particular use case.  I want to replace this line in a conf file with my own line:  Replace this line: #maxmemory &lt;bytes&gt; with: maxmemory 26gb  This is what I tried:  sed s/maxmemory.*bytes.*/maxmemory 26gb/ /etc/redis/redis.conf  I get the error: sed: -e expression #1, char 30: unterminated `s' command  Which stumps me because I don't know what that means. So my question is:  How can I accomplish what I want? What does that error mean? (so I can learn from it) Total space of a finite rank locally free sheaf, Vakil's 17.1.4 & 17.1.G Please add TeX rendering on the Android app How can I completely remove all traces of Java on my system?   I already know  in case I need it again. Regex match entire words only Amy: What day is it today?    Tom: It's Monday. Hmm... I like Monday.   Amy: What do you have today?   Tom: We have math, science and art.What about you?   Amy: We have English and P.E. What do you have tomorrow?    Tom: We have art and P.E.tomorrow.    Amy: Oh, great.      I can understand that "What about you" means "What do you have today?"  But I wonder whether "What about you" is an elliptical sentence. If it is, what is the full sentence? If it isn't, how to parse this structure? Basically, I would like to make it so that the lighter a pixel is (the more white it has) the more transparent it becomes. Black pixels would be opaque, white pixels would be transparent.  I currently use the slider in blending options on the first tab to get rid of the white and make it transparent but find it works slightly better if I use the magic wand tool with delete.  I figure that there is some blending option out there but there are so many and I'm not sure which to use to achieve my goal.  (Using Photoshop CS6) I was wondering how one can construct a Borel set that doesn't have full measure on any interval of the real line but does have positive measure everywhere.   To be precise, if $\mu$ denotes Lebesgue measure, how would one construct a Borel set $A \subset \mathbb{R}$ such that $$0 &lt; \mu(A \cap I) &lt; \mu(I)$$ for every interval $I$ in $\mathbb{R}$?   Moreover, would such a set necessarily have to contain infinite measure? I need this date format in a visualforce page: "December 14, 2013". I can't seem to find the format options for visualforce. I read that it's the same as the java messageformat class options, but I cannot find a list for that either.  A little help would be much appreciated How can I shutdown my Android phone using an adb command? How do I halt an android phone using adb command? I can reboot, but I don't know how to halt.  I tried shutdown -k wait command, but it did not work. Put   $$ l^{\infty} = \{ (x_n) \subseteq \mathbb{C} : \forall j \; \;\ \;|x_j| \leq C(x)\} $$  I want to show that $c_0$, the space of all sequences of scalars that converges to $0$ is closed subspace of $l^{\infty}$.  MY atttemt: Take arbitrary sequence $(x_n) \in c_0$. We know $x_n \to 0$. but $0 \in c_0$. Therefore, every sequence in $c_0$ converges to an element in $c_0$. Hence, $c_0$ must be closed  Is this correct? thanks Verbatim Environment in Figure Caption verbatim environment is not working in figure caption. Checked  and  is not working.  \documentclass[11pt, double space]{article} \usepackage{amsmath} \usepackage{graphicx} \usepackage{color} \usepackage[usenames,dvipsnames]{xcolor} \usepackage[english]{babel} \usepackage[autostyle, english = american]{csquotes} \MakeOuterQuote{"} \usepackage{cprotect}  \begin{document} \begin{figure}[!h] \caption{Sample 1 \cprotect\begin{verbatim} \tau(A) = e^{\chi_0A/(KD_p(K+A))} \end{verbatim} per hour.} \label{fig:singlecell_chemo} \end{figure}  \end{document}   I have tried cprotect package also. Any help.