MAX funkcija problemUser {UserId, FirstName}
i Tabelu
Salary {SalaryId, UserId, Value}
Hocu da uzmem najvecu platu iz salary i ime vlasnika te plate.
Probao sam prvo ovako ne ide vrati mi sve podatke...
Code:
SELECT u.FirstName, MAX(s.Values)
FROM T_User u INNER JOIN T_Salary s ON u.UserId = s.UserId
group by u.FirstName
SELECT u.FirstName, MAX(s.Values)
FROM T_User u INNER JOIN T_Salary s ON u.UserId = s.UserId
group by u.FirstName
Onda sam sklepao ovako nesto...
Code:
SELECT u.UserId, u.FirstName
FROM T_User u,
(select s.UserId, max(s.Values) as max_Sal
from t_salary s
group by s.UserId) mr
where u.userid = mr.userid
SELECT u.UserId, u.FirstName
FROM T_User u,
(select s.UserId, max(s.Values) as max_Sal
from t_salary s
group by s.UserId) mr
where u.userid = mr.userid
Mada i to radi isto
