SHARE
TWEET

Untitled

a guest Jul 20th, 2019 62 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Listę zadań z tabeli ISSUESS z dołączonymi do nich nazwami list zadań z tabeli ISSUESLISTS
  2. SELECT IL.NAME , I.SUMMARY
  3. FROM ISSUESLISTS IL
  4. JOIN ISSUES I ON IL.ID = I.ISSUESLIST_ID;
  5.  
  6. Listę zadań z tabeli ISSUESS z przypisanymi do nich użytkownikami z tabeli USERS
  7. SELECT U.FIRSTNAME, U.LASTNAME, I.SUMMARY
  8. FROM USERS U
  9. JOIN ISSUES I ON U.ID = I.USER_ID_ASSIGNEDTO;
  10.  
  11. Imiona i nazwiska użytkowników posiadających zadania, wraz z informacją o ilości zadań, które są do nich przypisane
  12. SELECT U.FIRSTNAME, U.LASTNAME, COUNT(*) AS ISSUES_NUMBER
  13. FROM ISSUES I JOIN USERS U ON I.USER_ID_ASSIGNEDTO = U.ID
  14. GROUP BY USER_ID_ASSIGNEDTO
  15. HAVING COUNT(*) > 1;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top