Query

Question

select Month(Logintime) as MonthYear(Logintime) as YearID as ID cast(Logintime as time) as LoginTime from UserLoginStatus where UserId=15 and Logintime IS NOT NULL Month Year ID LoginTime 10 2014 4 15:05:10.5500000 10 2014 5 15:06:14.9170000 If i write above query i am getting the above result But i need

Munesh Sharma · Answer

go here http://stackoverflow.com/questions/14193407/sql-server-get-min-time

Sasi Reddy · Answer

ID UserId Logintime Logut time 4 15 2014-10-13 15:05:10.550 NULL 5 15 2014-10-13 15:06:14.917 NULL 615 NULL 2014-10-13 15:06:20.270 From above table i need lowest login time and highest logout time for the particular user based on userid and based on date

Munesh Sharma · Answer

may be here column name smthing problem is cming .. you just put your table data i ll give u exact query..

Sasi Reddy · Answer

I am not getting values just empty i am getting

Munesh Sharma · Answer

use this SELECT * FROM UserLoginStatus where id IN(SELECT MAX(id) FROM UserLoginStatus )

Sasi Reddy · Answer

I need second row values only because it is max of ID

Munesh Sharma · Answer

what you need