Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
Next revision Both sides next revision
u3_databaser [2011-10-10 10:36]
Joakim Forsgren 		u3_databaser [2012-01-30 08:35]
Joakim Forsgren
Line 42: Line 42:
  
 <code SQL> <code SQL>
 +# Förslag på lösningar...
 4. select Valor as 'Valörer av kr', count(*) as antal from Pengar where Valuta='Kr' group by Valor; 4. select Valor as 'Valörer av kr', count(*) as antal from Pengar where Valuta='Kr' group by Valor;
 5. select count(distinct ar) as Antal from Datum; 5. select count(distinct ar) as Antal from Datum;