Ninja's_RGR'us (11/21/2011)

---

IE, this works, slow as hell =>

use master ;

;

WITH CTE ( object_id, summ )

AS (

...

I still want to learn on my own as always try to do. I searched for efficiency tests about the order by, max(), and so on. but nothing. Since you...

Ninja's_RGR'us (11/21/2011)

---

GilaMonster (11/21/2011)

---

But, since this is a kind of test (for a scholarship), you should really be doing this yourself, or will you share the prize with us if you...

Matt Miller (#4) (11/21/2011)

---

Ninja's_RGR'us (11/21/2011)

---

bomborde (11/21/2011)

---

Revenant (11/21/2011)

---

ScottPletcher (11/21/2011)

---

Don't see how you can do this w/o an ORDER BY, but it's trivial with one:

SELECT TOP 1 Name, SUM(Consumption) AS Total_Consumption

FROM tablename

GROUP...

ScottPletcher (11/21/2011)

---

To paraphrase Clinton, it depends on the definition of "work". If two people have the same...

Revenant (11/21/2011)

---

This...

Thanks!

GilaMonster (11/21/2011)

---

Do you know that or are you guessing? The entire table has to be retrieved and hashed...

GSquared (11/21/2011)

---

Not without an Order By, but a simple Sum() and Order By would do it. Do that all the time.

Is it a homework/test/interview type question, where artificial constraints...

An order will be inefficient because it will order the whole table. I dont want this. (imagine a table with 500k tuples). I just want the maximum.