Reputation
Top tag
Next privilege 50 Rep.
Comment everywhere
Badges
1 6
Impact
~9k people reached

  • 0 posts edited
  • 0 helpful flags
  • 1 vote cast
Aug
1
awarded  Notable Question
Jan
14
awarded  Popular Question
Dec
6
accepted How group with min(date) and select an another column in the same table
Dec
6
awarded  Teacher
Dec
5
awarded  Scholar
Dec
5
revised How group with min(date) and select an another column in the same table
added 1 characters in body
Dec
5
awarded  Supporter
Dec
5
answered How group with min(date) and select an another column in the same table
Dec
4
awarded  Student
Dec
4
comment How group with min(date) and select an another column in the same table
Thank you, it is working. My query look like this now : select name,gender,SUBSTRING(job, 9, 50) as 'jobname' from( select name,gender,min(CONVERT(CHAR(8), hiredate, 112)+jobname) as'job' from person p left join job j on p.personid = j.personid group by name ) as query
Dec
4
awarded  Editor
Dec
4
revised How group with min(date) and select an another column in the same table
added 156 characters in body
Dec
4
asked How group with min(date) and select an another column in the same table