خرید بک لینک

Vote count: 0

The Table is

SUPERVISION (ResNo, ActivityID, SupervisorID, Day, Time)

I have done something like this but it is wrong

SELECT COUNT(S.Res, S.ActivityID) AS PopularActivities FROM Supervision S WHERE rownum = 2; ORDER BY COUNT(*) DESC;

or

SELECT S.ResNo, S.ActivityID FROM Supervision S WHERE (rank() over (order by count(*) DESC) as RNK from Supervision S) AND k = 2;

asked 1 min ago

برچسب: نویسنده: استخدام کار تاريخ: سه شنبه 11 خرداد 1395 ساعت: 12:04

صفحه بندی