how to find max and min value of a time column

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

Hello All,

I have a scenario in which i have a column "Time" in a table, noiw i have to find the max and min value of time according to date for eachy employee in 2 other colmns, i am trying to do it using RowNumber() function...

Is it right or any other suggestions...??

Posted 26-Aug-13 19:37pm

abhishekagrwl25

Add a Solution

Comments

Thanks7872 27-Aug-13 1:48am

What you want from us? Answer you with what? Question is not cleat at first place then no suggestions can be made.

abhishekagrwl25 27-Aug-13 2:00am

RowID EmployeeID Time Access_Date
2 9007 14:45:43 2011/09/20
3 9007 14:49:50 2011/09/20
4 9007 14:45:43 2011/09/20
5 9007 14:49:50 2011/09/20

Above is the table from which i want to make a new table with column named(EmployeeID, In_Time, Out_Time,Access_Date) in which In_Time will be the Min time for respective date and Out_Time will be the max time for date for particular employee...

i need this for creating a report in ASP.Net...

2 solutions

Solution 1

Try:

SQL

SELECT employee, MAX(myDateColumn) AS MaxDate, MIN(myDateColumn) AS MinDate FROM MyTable GROUP BY employee

Posted 26-Aug-13 19:57pm

OriginalGriff

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

phil.o · Accepted Answer · 2013-08-26T20:11:00

Solution 2

Hi,

This :

SQL

SELECT [RowID], [EmployeeID], [Access_Date], MIN([Time]) AS MinTime, MAX([Time]) AS MaxTime FROM [TableName] GROUP BY [EmployeeID], [Access_Date]

should do it. I included the [Access_Date] column to get min and max times grouped by dates.
Hope this helps.

Posted 26-Aug-13 20:11pm

phil.o

Updated 26-Aug-13 20:12pm

v2