> > >

SQL MCQs

Consider the following Attendance table which contains an employee attendance record for a company:
EmployeeID (int), LoginTime (time), LogoutTime (time)
Which of these SELECT statements will list the employee ID that has logged-in most recently?

SELECT EmployeeID

FROM Attendance

GROUP BY LoginTime

HAVING MAX(LoginTime)

SELECT TOP 1 a.EmployeeID

FROM Attendance a

WHERE EXISTS (SELECT MAX(b.LoginTime) FROM Attendance b GROUP BY EmployeeID HAVING MAX(b.LoginTime) = a.LoginTime AND a.EmployeeID = b.EmployeeID )

SELECT TOP 1 a.EmployeeID

FROM Attendance a

WHERE a.LoginTime = (SELECT MAX(b.LoginTime) FROM Attendance b)

None of the above

Answer

Correct Answer:

SELECT TOP 1 a.EmployeeID

FROM Attendance a

WHERE a.LoginTime = (SELECT MAX(b.LoginTime) FROM Attendance b)

Explanation:

Note: This Question is unanswered, help us to find answer for this one

SQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it