Pastebin
API
tools
faq
paste
Login
Sign up
SHARE
TWEET
Untitled
a guest
Oct 19th, 2018
114
0
Never
Add comment
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!
text
0.18 KB
| None
|
0
0
raw
download
clone
embed
print
report
SELECT ID, NAME, CHIEF_ID, SALARY, DEPARTMENT_ID
FROM EMPLOYEE A
WHERE SALARY/2 = (SELECT AVG(SALARY)
FROM EMPLOYEE B
WHERE A.DEPARTMENT_ID = B.DEPARTMENT_ID AND A.CHIEF_ID = A.ID)
Add Comment
Please,
Sign In
to add comment
Public Pastes
Освоение циклов
C# | 54 sec ago | 0.52 KB
CarpetBackup
Lua | 1 min ago | 1.62 KB
Magenta style
LScript | 3 min ago | 36.36 KB
Shinada style
LScript | 9 min ago | 20.90 KB
Breaker style 1st
LScript | 17 min ago | 36.78 KB
Breaker style 2rd
LScript | 19 min ago | 36.04 KB
🤑 G2A.com Free Gift Card Guide May 2024 FIX 🤑
GetText | 23 min ago | 0.39 KB
Villian style
LScript | 26 min ago | 39.23 KB
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
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!