mysql - Retrieve the name of each employee who works on all the projects controlled by department number 5 -

-

यह प्रश्न डाटा फाउंडेंटल्स ऑफ डाटाबेस सिस्टम 6 वें संस्करण (एलमास्त्री, नवाथ) अध्याय 5 क्वेरी 3 बी से लिया गया है। एक तरह से लेखकों ने यह उत्तर दिया है कि अस्तित्विक क्वांटिफ़ायर: SELECT Lname, Fname FROM कर्मचारी जहां मौजूद नहीं है (चयन करें * WORKS_ON B WHERE (बी.पी.एन.ई. में (परियोजना का चयन संख्या, जहां डनम = 5) और मौजूदा नहीं (SELECT * WORKS_ON सी से WHERE C.Essn = एसएसएन और सी.पी.एन. = बी.पी.एन. नो))); लेखकों ने इस समाधान को समझाया है:
"प्रत्येक कर्मचारी का चयन करें कि विभाग 5 द्वारा नियंत्रित एक परियोजना मौजूद नहीं है जो कि कर्मचारी पर काम नहीं करता"।
मैं समझ नहीं पा रहा हूं कि दूसरा आंतरिक सहसंबद्ध उप-क्वेरी सही परिणाम देने के लिए अन्य असंगठित subquery और बाहरी क्वेरी से संबंधित है।
कोई भी मदद की सराहना की जाती है धन्यवाद


Comments

Post a Comment

Popular posts from this blog

Folder list php -

-
I want to list folder names in the list. There is a file to show the folder name. There is already a problem, please do a test. Another code would be OK. & lt ;? Php function getFileList ($ folder name, $ fileType = "") {if (substr ($ folderName, strlen ($ folderName) - 1)! = "/") {$ Folder name. = '/'; } Foreach (Globe ($ folderName. '*'. $ FileType) $ filename) {if_dir ($ filename)) {$ type = 'folder'; } And {$ type = 'file'; } Echo str_replace ($ folderName, '', $ filename. ' '); }} // call function getFileList ('folder name'); // List of all files? & Gt; & Lt; Select class = "form" name = "userlevel" size = "1" & gt; & Lt; Option value = "& lt ;? php getFileList ('theme') ;? & gt;" & Gt; فولدر 1 & lt; / Options & gt; & Lt; Option value = "& lt ;? php getFileList ('theme') ;? & gt;" ...
Read more

symfony - FOSUser mail is translated but confirmation_url isn't -

-
I found an easy way to add a location to my Symphony routes, as here: Some of the relevant settings in my project: Config Framework: Translator: {Fallback: "% locale%"} default_lock: Nl Services FOSMailer: @ FOS_UJ. Mailer. Twig_swift Routing fos_user_register: resource: "@ FOSUserBundle / resources / config / routing / registration.xml" Prefix: / {_ locale} / registreren I am trying to get FOSUser to send confirmation mail in the newly created user's browser language. For this, I am saving the place I have received by Javascript in my database. Then, I am setting up my request for that locale and manually send the confirmation mail: $ request-> Setlokel ($ locale); // ($ locale = 'en_US') $ Mailer = $ this- & gt; Get ('fosmailer'); $ Mailer- & gt; SendConfirmationEmailMessage ($ user); In the email template {{'foobar' | Trans}} tags that work perfectly fine. But I am also using {{confi...
Read more

java - org.apache.http.ProtocolException: Target host is not specified -

-
I have written a simple httprequest / response code and I am getting this error below: I used to type in my classpath httpclient, httpcore, common -Codecs and general logging. I am very new to Java and I do not know what's going on here. Please help me. code: import org.apache.http.client.HttpClient; Import org.apache.http.client.methods.HttpGet; Import org.apache.http.HttpResponse; Import org.apache.http.impl.client.HttpClientBuilder; Import org.apache.http.Header; Import org.apache.http.HttpHeaders; Public class UnshorteningUrl {public static zero main (string [] args throws exception {HttpGet request = zero; HTTP Client Client = HTTP ClientBuilder.credit (). Build (); Try {Request = New HTTP Gate ("trib.me/1lBFzSi"); HttpResponse httpResponse = client.execute (request); Header [] header = httpResponse.getHeaders (HttpHeaders.LOCATION); // Preconditions.checkState (headers.length == 1); String new url = header [0] .getValue (); System.out.println ("new url...
Read more