Re: [SQL] Data Comparison Single Table Question

2008-04-16 Thread Osvaldo Rosario Kussama
Bryan Emrys escreveu: I can handle this outside sql, but it seems like I should be able to do this in sql as well. 1 table: countries. 3 columns: id, name, price What I'm trying to get is a result of the price differences between every country. So if the data looks like (ignoring the id fie

[SQL] Data Comparison Single Table Question

2008-04-16 Thread Bryan Emrys
I can handle this outside sql, but it seems like I should be able to do this in sql as well. 1 table: countries. 3 columns: id, name, price What I'm trying to get is a result of the price differences between every country. So if the data looks like (ignoring the id field) Taiwain 30 UK 50 U