SQL, getting the same results for both LOWER and UPPER

Hi,

I have this SQL statement:
SELECT DISTINCT type, COUNT(type), LOWER(price), UPPER(price) FROM products WHERE system = 'abc' GROUP BY type ORDER BY type

Problem is that LOWER and UPPER give me the same results - but when I look at the date, the results should be different.

Any idea what is wrong with the statement and how I can fix it, so I get different results for LOWER and UPPER? (i.e. the lowest price for the type and the highest price for the type)

Thanks,
Mads

 

LOWER and UPPER are used like:
select LOWER('AAA') from table --> result: aaa
select UPPER('bbb') from table --> result: BBB
In your case you have numbers, you can use min(price) and max(price).

 

Edit...

What you're doing makes no sense. As stated above, LOWER and UPPER are character functions. Also, DISTINCT and GROUP BY are performing the same function in your example. Get rid of the DISTINCT. What are you trying to accomplish?

 

Hi
i have server load problem and the server provider or automatically website use to stop any body can help me

 

Not with the limited amount of information you gave us.

 

Can any one explain me about the inner queries how they work.Explain about the joins too?

 

Try http://beginner-sql-tutorial.com/sql-joins.htm