Database

SELECT SKU, TITLE, AVG(PRICE), SUM(QUANTITY), SUM(TOTAL_PRICE)<br />
FROM MyTable<br />
ORDER BY SKU, TITLE

udikantz wrote:

Group BY SKU, TITLE
and not
ORDER BY SKU, TITLE

udikantz wrote:

well that is not working for me , Cause my table contain a few more fields i didnt mention in the example

select case when c1 = '31-dec-9999' then null else c1 end as c1 <br />
from (<br />
	select top 1000 * <br />
	from (<br />
			select case when c1 is null then '31-dec-9999' else c1 end as c1 from a <br />
		)a order by c1<br />
	)a

sjp700 wrote:

Any help would be aoppreciated. I'm trying to pass the login username information into a sql table filter on column containing names. I have tried WHERE statement but can't find how pick-up user name.

logan1337 wrote:

Hi all. I'm wondering if there is a means in SQL to delete a certain number of rows from a table, when ordered a certain way. In other words, I want to be able to say something like this:

delete the 10 oldest rows where <some condition=""> applies

DELETE<br />
FROM MyTable<br />
WHERE ID IN (SELECT TOP 10 ID FROM MyTable ORDER BY HistoricalDate)