Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- business.businessid,
- person.personid,
- remuneration.salary + remuneration.bonus AS "Total"
- person.id IN
- (SELECT
- person.id
- FROM
- person INNER JOIN remuneration ON person.personid = remuneration.personid
- WHERE
- remuneration.salary + remuneration.bonus || ', ' || person.personid =
- (SELECT
- MAX(remuneration.salary + remuneration.bonus) || ', ' || person.personid
- FROM
- person INNER JOIN remuneration ON person.personid = remuneration.personid))
Add Comment
Please, Sign In to add comment