Hi ! All
I have a database TSQLFundamental2008, there I am trying to create a simple select query from Sales.Orders table. I am attaching two images for two different queries (Please go through the images),
where in one I have used a group by clause with empid, YEAR(orderdate) ;These two attributes. In another case i.e. in 2nd query I have made small change, rather than two I used 3 fields( added freight as a field under group by clause).Now if you go through the two O/P as showed in two images(query1.jpeg, query2.jpeg) that I have attached you will finds difference in those, I am also attaching the table structure of the Sales.Orders(table-Sales.Orders.jpeg). Can any body please tell me why two O/P are comming differently?