dkanavis

Untitled

Oct 18th, 2016
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.19 KB | None | 0 0
  1. UPDATE
  2.     Departments
  3. SET
  4.     Budget = Budget * 2
  5. WHERE
  6.     Code =
  7.     (
  8.         SELECT
  9.             Department
  10.         FROM
  11.             Employees
  12.         GROUP BY
  13.             Department
  14.         ORDER BY
  15.             COUNT(SSN)
  16.         DESC
  17.         LIMIT
  18.             1
  19.     )
Advertisement
Add Comment
Please, Sign In to add comment