28 reputation
16
bio website
location Quebec, Canada
age
visits member for 1 year, 10 months
seen Jan 14 '13 at 18:48

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