How to show the longest days?

[coco]

I have a table with 2 fields: FTE# and Workingdays.

FTE# Workingdays
MR301 477
MR413 45
MR303 26
MR312 77
MR316 149
MR404 5
MR408 180

I need to write a query to show the result (whole record, not the number only):
MR301 477

I know how to show the number - 477. But how to show MR301 also? (Both fields)
One more question: what if there have two "477" in the table, how to show both record?

Here is the query what I'm having right now:
SELECT Max(Workingdays) AS Longestdays
FROM Table;

Please help. Thanks for your help.

coco

 

[Liv Manto]

Paste on SQL


Select Table1.Workingdays, Table1.FTE FROM Table1 where Table1.Workingdays = (
SELECT Max(Table1.Workingdays) AS MaxOfWorkingdays
FROM Table1)