Query to find three times greater than the other records
794374Aug 27 2010 — edited Aug 28 2010hi All,
I am new to this forum, please help me out on this issue.
There is a table named as regions which has following columns like name, region, population, area with the following sample records
Region Name Population
AAA AAAA 1000
AAA BBBB 2000
AAA CCCC 500
BBB DDDD 900
BBB EEEE 300
I need to pick the record which has population more than three times that of any of their neighbours (in the same region). I need to get the region and name as the output. Please help me on how to write this query.