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

GO: Serve static pages -

-
I'm trying to display a static page with Go. Go: Package main import "net / http" function main () {fs: = http.FileServer (http.Dir ("static / house")) Http: .handle ("/", fs) http.ListenAndServe (": 4747", zero)} directory: project / stable home Html edit.html project.go When I run it, the web page displays links to edit.html and home.html instead of displaying a static page from home.html is. What am I doing wrong. Is this the best way to serve files? I know that there are other ways like From the HTML / templates package, but I'm not sure what is the difference between each of these methods and when. Thanks! fancy main () {http.Handle ("/", http.FileServer (Http) .ir ("static")) http.ListenAndServe (": 4747", zero)} You do not need static / home , just Static . and when you do not have index.html in / static , the directory instead Content appears. Just change the name of...
Read more

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

java - how to parse a JSON string into ObjectNode in Jackson? -

-
First of all, can anyone explain, what is the difference between the object node and the jesenand, and where did they use it? Then what can I do if I want to convert a JSON string to ObjectNode? You can: object mapper mapper = new object On mapper (); JsonNode realObj = mapper.valueToTree ("{\" k1 \ ": \" v1 \ "}") JsonNode is a super class of this object node. You can find differences in the API.
Read more