Skip to main content

Return to Question

deleted 1 characters in body
Source Link
subash
subash
  • 4.2k
  • 15
  • 54
  • 81

i have a table like below

Name Entrytime Exittime A 10:30 AM 6:30PM A 7:30 AM 5:30PM B 10:30 AM 2:30PM A 5:30 AM 3:30PM B 11:30 AM 4:30PM A 128:30 AM 7:30PM C 9:30 AM 1:30PM C 10:30 AM 9:30PM

i need to get a record minimum entry time for each Name and maximum exittime for eachname using linq query

so i need resultset like below

Name Entrytime Exittime A 5:30 AM 7:30PM B 10:30 AM 4:30PM C 9:30 AM 9:30PM

i have a table like below

Name Entrytime Exittime A 10:30 AM 6:30PM A 7:30 AM 5:30PM B 10:30 AM 2:30PM A 5:30 AM 3:30PM B 11:30 AM 4:30PM A 12:30 AM 7:30PM C 9:30 AM 1:30PM C 10:30 AM 9:30PM

i need to get a record minimum entry time for each Name and maximum exittime for eachname using linq query

so i need resultset like below

Name Entrytime Exittime A 5:30 AM 7:30PM B 10:30 AM 4:30PM C 9:30 AM 9:30PM

i have a table like below

Name Entrytime Exittime A 10:30 AM 6:30PM A 7:30 AM 5:30PM B 10:30 AM 2:30PM A 5:30 AM 3:30PM B 11:30 AM 4:30PM A 8:30 AM 7:30PM C 9:30 AM 1:30PM C 10:30 AM 9:30PM

i need to get a record minimum entry time for each Name and maximum exittime for eachname using linq query

so i need resultset like below

Name Entrytime Exittime A 5:30 AM 7:30PM B 10:30 AM 4:30PM C 9:30 AM 9:30PM
Source Link
subash
subash
  • 4.2k
  • 15
  • 54
  • 81

get distinct with min and maximum in linq query

i have a table like below

Name Entrytime Exittime A 10:30 AM 6:30PM A 7:30 AM 5:30PM B 10:30 AM 2:30PM A 5:30 AM 3:30PM B 11:30 AM 4:30PM A 12:30 AM 7:30PM C 9:30 AM 1:30PM C 10:30 AM 9:30PM

i need to get a record minimum entry time for each Name and maximum exittime for eachname using linq query

so i need resultset like below

Name Entrytime Exittime A 5:30 AM 7:30PM B 10:30 AM 4:30PM C 9:30 AM 9:30PM