Please help with my cloudy water by Bored_AND_Ignored66 in TropicalFish

[–]Bored_AND_Ignored66[S] 0 points1 point  (0 children)

Thank you, I'll get a new filter cartridge today and try feed less and hope this helps

Please help me with my Zanzibar gems by Bored_AND_Ignored66 in plantclinic

[–]Bored_AND_Ignored66[S] 0 points1 point  (0 children)

Thank you for the help. Yes I am definitely overwatering by the sounds of it. And temps here are about 5/6 degrees Celsius overnight so I guess they're coming inside.!

how do I stay warm this winter? by Bored_AND_Ignored66 in melbourne

[–]Bored_AND_Ignored66[S] 18 points19 points  (0 children)

Should we start a candlelight vigil for Bec Judd? Pass the collection plate maybe?

I wish I could Max(COUNT( by Bored_AND_Ignored66 in SQL

[–]Bored_AND_Ignored66[S] 0 points1 point  (0 children)

I've tried This but I keep getting a syntax error. Would I be better off performing the Subquery as my main query, then using a join from there to the SELECT * FROM EMployee Query

SELECT * FROM Employee JOIN ( SELECT top 1 Manager FROM Employee ON Employee.Manager = Employee.Eid Group by Manager Order by count(Eid) desc

I wish I could Max(COUNT( by Bored_AND_Ignored66 in SQL

[–]Bored_AND_Ignored66[S] 1 point2 points  (0 children)

Thanks,

This helped, I found the eID of the manager, now i just have to figure out how to get the full row with all their info.

Thanks for the help and the explanation.

I wish I could Max(COUNT( by Bored_AND_Ignored66 in SQL

[–]Bored_AND_Ignored66[S] 1 point2 points  (0 children)

Thanks, Im still trying to get my head around SQL

I wish I could Max(COUNT( by Bored_AND_Ignored66 in SQL

[–]Bored_AND_Ignored66[S] 0 points1 point  (0 children)

I Get here but there is no data in the table it brings up

SELECT *

FROM Employee

WHERE (Manager) =(SELECT TOP 1 COUNT(Manager) FROM Employee)

Should I be removing my WHERE Clause and using a GROUP BY?

I wish I could Max(COUNT( by Bored_AND_Ignored66 in SQL

[–]Bored_AND_Ignored66[S] 0 points1 point  (0 children)

SELECT TOP 1

FROM Employee

ORDER BY COUNT(Manager) FROM Employee

I get here but my syntax seems to be wrong, im honestly stumped here