Witam,
Posiadam takie dane
ALT_KEY_HIST DATA ID_TOWARU
E759B73E-7134-4E15-A7A9-617C168EF655 2011-07-07 10:58:17.957 004623
37208C0C-14CD-4B5C-A71D-7329E0677D41 2011-08-26 17:02:58.350 004623
232DC61A-509B-4078-9210-7491077404DB 2011-07-29 07:40:17.713 004623
D1E799E8-5249-4A3B-8BBA-C12201294B97 2011-07-13 11:54:40.150 004623
5FD9332B-94A3-4ADD-8336-C8956E8D6694 2011-07-07 10:58:17.953 004623
F20142ED-5FE2-4C9D-8A1D-D200623397E3 2011-07-13 11:54:40.153 004623
49DAFBAC-F920-404B-99AE-D980445D755A 2011-08-26 18:02:22.297 004623
D759B73E-7134-4E15-A7A9-617C168EF655 2012-07-07 10:58:17.957 004624
27208C0C-14CD-4B5C-A71D-7329E0677D41 2012-08-26 17:02:58.350 004624
132DC61A-509B-4078-9210-7491077404DB 2012-07-29 07:40:17.713 004624
C1E799E8-5249-4A3B-8BBA-C12201294B97 2012-07-13 11:54:40.150 004624
4FD9332B-94A3-4ADD-8336-C8956E8D6694 2012-07-07 10:58:17.953 004624
E20142ED-5FE2-4C9D-8A1D-D200623397E3 2012-07-13 11:54:40.153 004624
39DAFBAC-F920-404B-99AE-D980445D755A 2012-08-26 18:02:22.297 004624
Chciałbym wybrać stąd:
ALT_KEY_HIST DATA ID_TOWARU
49DAFBAC-F920-404B-99AE-D980445D755A 2011-08-26 18:02:22.297 004623
39DAFBAC-F920-404B-99AE-D980445D755A 2012-08-26 18:02:22.297 004624
Jak powinno wyglądać zapytanie?
SELECT ALT_KEY_HIST, max (DATA), ID_TOWARU FROM tabela group by ID_TOWARU
Co nałożyć na ALT_KEY_HIST? Bo w tym wypadku jest
Msg 8120, Level 16, State 1, Line 1
Column 'qin.ALT_KEY_HIST' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.