I have one table like  |-----------------|-------------------|-------------------| | CONTACTGROUPID  |   CONTACTID       |  GROUPID          | |-----------------|-------------------|-------------------| |              23 |           7       |        35         | |              22 |           8       |        35         | |              24 |           9       |        35         | |              34 |           8       |        40         | |-----------------|-------------------|-------------------|   i Want the GROUPID '35' for CONTACT (7,8,9).  I run the mysql query like =   SELECT GROUPID FROM dpms_contactgroupmaster WHERE CONTACTID IN (8,7,9) GROUP BY GROUPID   But its give me 35,40 group id. i want 35 only....How can i do that.
This is a very basic query I can't figure out....  Let's say I have a two column table like this:  userid  |  roleid --------|--------    1    |    1    1    |    2    1    |    3    2    |    1   I want to get all distinct userids that have roleids 1, 2 AND 3.  Using the above example, the only result I want returned is userid 1.  How do I do this?
Is it true that $||a|^p - |b|^p| \le C_p|a - b|^p$ for $1 < p < \infty$? If $a, b \in \mathbb{C}$, then we have the standard triangle inequality for the difference:  $$||a| - |b|| \le |a - b|.$$  I am wondering if this inequality generalizes to exponents greater that one.     My question is, for $1 &lt; p &lt; \infty$, does there exists a constant $C_p$ such that $||a|^p - |b|^p| \le C_p|a - b|^p$ for all $a, b \in \mathbb{C}$?   I am aware of the "standard" triangle inequality for $p &gt; 1$:  $$|a +b|^p \le 2^{p}(|a|^p + |b|^p),$$  and that $2^p$ may not be sharpest constant possible. If I try to use this estimate to prove, say, that $|a|^p - |b|^p \le C_p |a - b|^p$, I get stuck with an extra term that I'm not sure what to do with.  $$|a|^p - |b|^p \le 2^p|a -b|^p + (2^p -1)|b|^p.$$  A resolution on this matter is greatly appreciated. Elegant proofs that similar matrices have the same characteristic polynomial? How can I prove the formula for calculating successive entries in a given row of Pascal's triangle? I've found in Wikipedia the formula for calculating an individual row in Pascal's Triangle: $$v_c = v_{c-1}\left(\frac{r-c}{c}\right).$$ where $r = \mathrm{row}+1$, $c$ is the column starting from $0$ on left and $v_0 = 1$.  Now, I've tried to do by hand and it works,  but I don't understand how to find this magic formula when I don't have access to Wikipedia...:) How can I hide username and computer in terminal command prompt?   In Terminal it says  Last login: Mon Jan 13 00:00:14 on ttys000 Whatever:~ UserName$    Is it possible to show just the current folder and $ sign? How to clean an E: drive (new Recovery drive since Windows 10 1803) on HP laptop My Developer Account cannot be activated because I used a relative's credit card LWC Get Pick-list Field Values In LWC, is it possible to get a pick-list field's possible values?  I'm writing a component that is embded into a lightning record page. I need my component to be able to load the record from the page, get data from the fields and use that data to pre-populate my search form with default values.  I have this working with city/state and checkbox fields. Right now the city/state fields are built pull data from an aggregate query of contacts to find all possible state/city combinations (I know this is doomed to fail when the records reach over 50k contacts but Its good enough for now).  I have a pick-list field on my object called skill level, I need to be able to build a combo box that has all the possible values for skill level and set the default value to the value on the associated record.  I'd like to avoid hard-coding the available options if possible.  In LWC, is it possible to get a pick-list field's possible values? Add a time limit before you can vote on a post There needs to be a timer or something on upvoting/downvoting.  I posted an answer to a question and as soon as the page loaded, my answer was already down voted. There is no way someone had the time to read the answer &lt; 10 seconds after it was posted. Neural network references (textbooks, online courses) for beginners I want to learn Neural Networks.  I am a Computational Linguist. I know statistical machine learning approaches and can code in Python.   I am looking to start with its concepts, and know one or two popular models which may be useful from a Computational Linguistics perspective.  I browsed the web for reference and found a few books and materials.   Ripley, Brian D. (1996) Pattern Recognition and Neural Networks, Cambridge Bishop, C.M. (1995) Neural Networks for Pattern Recognition, Oxford: Oxford University Press. some links, like ,  (University of Toronto Psychology Department),  (University of Wisconsin Computer Science) and  (Facebook Research).   Coursera courses are generally nice, if anyone knows anything relevant from them. I prefer materials with lucid language and ample examples. Playing a remote movie on the remote computer I have two computers (a desktop and a laptop) running linux connected to my local area network. I like to ssh from my laptop over to my desktop and run programs there, and sometimes listen to music on my desktop, which is connected to my stereo system. Lately, I've been wanting to play movies on the desktop and desktop screen, but cue them from my laptop across the room.   Unfortunately, I cannot play a movie in the current X session running on my Desktop on from my laptop. What is odd about this is that I can listen to the audio coming from the speakers that are hooked up to my desktop, by playing the audio files over ssh! This tells me that there must be a way to send the movie to that Xsession, from the ssh shell that I am connected to.  Does anyone have any ideas about this? I have the following diagram:  \documentclass{article} \usepackage{amsmath,amsfonts,graphicx} \usepackage{algpseudocode} \usepackage{tikz, nth} \usetikzlibrary{arrows.meta,decorations,decorations.pathreplacing,calc,bending,positioning, chains}  \begin{document} \begin{tikzpicture}[scale=0.6]         \draw[thick,]  (0,8) -- (0,0) node[left] {0};         \draw[thick,]  (0,0) -- (8,0) node[right] {8};         \draw[thick,]  (8,8) -- (8,0) node[left] {};         \draw[thick,]  (8,8) -- (0,8) node[left] {8};          \draw[thick,]  (4,0) -- (4,8) node[left] {};          \fill (1, 4) circle[radius=2.5pt] node[below]{$A$};         \fill (2, 6) circle[radius=2.5pt] node[below]{$B$};         \fill (3, 2) circle[radius=2.5pt] node[below]{$C$};         \fill (4, 8) circle[radius=2.5pt] node[below]{$D$};         \fill (7, 3) circle[radius=2.5pt] node[below]{$E$};         \fill (6, 1) circle[radius=2.5pt] node[below]{$F$};         \fill (5, 7) circle[radius=2.5pt] node[below]{$G$};         \fill (3, 8) circle[radius=2.5pt] node[below]{$H$}; \end{tikzpicture} \end{document}   How can I position the caption of the node $D$ both below and left, so that the line doesn't obscure the caption? Code working in jsFiddle but not in browser Let  $f(xy) =f(x)f(y)$ for all $x,y\geq 0$. Show that $f(x) = x^p$ for some $p$.    I am not very experienced with proof. If we let $g(x)=\log (f(x))$ then this is the same as  $g(xy) = g(x) + g(y)$   I looked up the hint and it says let $g(x) = \log f(a^x) $   The wikipedia page for functional equations only states the form of the solutions without proof.  Attempt  Using the hint (which was like pulling a rabbit out of the hat)  Restricting the codomain $f:(0,+\infty)\rightarrow (0,+\infty)$ so that we can define the real function $g(x) =  \log f(a^x)$ and we have $$g(x+y) = g(x)+ g(y)$$   i.e $g(x) = xg(1)$ as $g(x)$ is continuous (assuming $f$ is).  Letting $\log_a f(a) = p$ we get $f(a^x) =a^p $. I do not have a rigorous argument but I think I can conclude that $f(x) = x^p$ (please fill any holes or unspecified assumptions) Different solutions are invited Can't mount ISO file as loop device: Error: “failed to setup loop device” sudo mkdir -p /media/cdrom cd ~ sudo mount -o loop ubuntu-* / mount: ubuntu-*: failed to setup loop device: No such file or directory get value part of specific word in AIX want to search string and need part of string  file.txt:  CREATE MULTISET TABLE $$ENV$$_TEMP_ESM.EMPASGMTAMPTMPRTRSE, NO FALLBACK ,      NO BEFORE JOURNAL,      NO AFTER JOURNAL,      CHECKSUM = DEFAULT,      DEFAULT MERGEBLOCKADSRATIO   while using below sed command getting extra value  Output:   bash-4.3$ sed -n 's/.*$$ENV$$_//p' file.txt  **TEMP_ESM.EMPASGMTAMPTMPRTRSE** ,NO FALLBACK ,   I need only TEMP_ESM.EMPASGMTAMPTMPRTRSE What does it mean for two objects to "touch"? If you've ever been annoyingly poked by a geek, you might be familiar with the semi-nerdy obnoxious response of      "I'm not actually touching you! The electrons in the atoms of my   skin are just getting really close to yours!"   Expanding on this a little bit, it seems the obnoxious geek is right. After all, consider Zeno's paradox. Every time you try to touch two objects together, you have to get them halfway there, then quarter-way, etc. In other words, there's always a infinitesimal distance in between the two objects.   Atoms don't "touch" each other; even the protons and neutrons in the nucleus of an atom aren't "touching" each other.  So what does it mean for two objects to touch each other?   Are atoms that join to form a molecule "touching"? I suppose the atoms are touching, because their is some overlap, but the subatomic particles are just whizzing around avoiding each other. If this is the case, should "touching" just be defined relative to some context? I.e, if I touch your hand, our hands are touching, but unless you pick up some of my DNA, the molecules in our hands aren't touching? And since the molecules aren't changing, the atoms aren't touching either?  Is there really no such thing as "touching"? Why has the role of Bruce Banner been played by different actors in the three films that Hulk has appeared in? Hulk (2003) Eric Bana Bruce Banner  The Incredible Hulk (2008) Edward Norton Bruce Banner  The Avengers (2012) Mark Ruffalo Bruce Banner  Is there any reason why different actors are used in different versions of the same role? Can't install xposed framework I want to install the xposed framework on my Nexus 5 and in the framework, the install/update option doesn't work.  My Nexus 5 runs Android 5.0 (Lollipop). Dual Canadian and British citizen - healthcare coverage in the UK? Usually a probability distribution over discrete variables is described using a probability mass function (PMF):  When working with continuous random variables, we describe probability distributions using a probability density function (PDF) rather than a probability mass function. -- Deep Learning by Goodfellow, Bengio,  and Courville  However,  is using PDF to describe the probability distribution over discrete variables:    Is this a mistake? or it does not much matter?