SQL Query Question

[grimmy]

Hello,<br>I am an NT4 administrator by trade but I am studying Relational Databases as part of my O.U and I have a question I am struggling on which is probably a piece of cake to you guys. Any help would be greatly appreciated. The question is:-<br>Give the name and the population growth of the country in the population table that achieved the highest growth between 1960 and 1980(based on the difference between those two dates.<br><br>Population Table&nbsp;&nbsp;(Only Some of it)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;POP.1960&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;POP.1980&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DIFFERENCE<br>Germany&nbsp;&nbsp;&nbsp;&nbsp;72673&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;78395&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+5722<br>Greece&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;8327&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;9646&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+1319<br>Spain&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;30303&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;37458&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+7155<br>France&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;45684&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;53788&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+8104<br><br>So obviously above the query would give an answer of France but I just need the SQL query that will extract the info required.<br><br>Thanks in anticipation.....Paul.<br><br><br><br><br><br><br><br><br><br>

 

[MalcolmW]

Just so that you have to do some of the work, use the Max function, which can be used with a expression, not just a field. <p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>