Comments by ImNAM (Top 2 by date)

I tried selecting max(logDate) (and aslo TOP 1) ..
When I try to implement order by on logDate, it fails and gives me some multiple user listing.
Also when I want to implement WHERE clasuse on logDate, it fails..
again, I want to describe the table structure..

User Table
-----------
usrSrNo INT, usrName VARCHAR

logTable
----------
logSrNo INT, logType, logDateTime, usrSrNo

logTable can have multiple entries for same user on same date.
I want to show list of users based on selection like, today, this week, this Month (they should be sorted by logDate DESC)

I also tried with creating View with joint on both tables, It works when I dont have to mention date range, but when I mentione date range in WHERE clause, it fails. as I want to order by, I need to mention logDate in select.. and once I mention it into select.. it returns multiple values.