Hello Brothers
i want query to get last Login Char
Printable View
Hello Brothers
i want query to get last Login Char
Here you go, enjoy!
Code:-- Get latest logged in Char
USE [Log_DB] -- Check the DB Name
WITH GetLogins AS (
SELECT CharID, EventTime
FROM _LogEventChar
WHERE EventID= 4
)
SELECT CharID, EventTime
FROM GetLogins
WHERE EventTime=(SELECT MAX(EventTime) FROM GetLogins)
-- by Zorbas for arabcart