【技术贴，SQL，测试题】一个表里有一个内容为随机数的字段，想知道所有记录中，该字段内容最接近、最不接近的差额为多少？
如：tb1
frnd other fields
6
2
3
最接近、最不接近的差额为1(=3-2)和4(=6-2)


试用较简单的sql实现
开始以为不使用游标做不到，后来一试，还真有个简单的做法。。。。。。


答案：
[#@JiaMi@#]4jX0S5hzX2XWR435V5W9HP5Ocx0jItOoWaiSN/3dWKm4rJIlrvfJBGzClvTsPBpgnK1YWiQmJecWR7/pxhwHkbePB7LoHMMhey7LA34O3KIt8YNKKg11sDNrByZg
[#@JiaMi@#]JADrEBOzsjZ0aLSjaDKoNW285aCLEJtCiTROP17MBQY4XQP3Uz/YInHka4aRXhHFZ3YUgMaVNGXSlnoV0+Q=
[#@JiaMi@#]IMT0N98MLPAlzeJ3OgU3XYMHvPGv4X7itvB2dYbMDt5w/erQxn6ySZzx0agtobrcNu6Ixz4EoQ73fpWtOVr4o4hYn5SGizCev++YT0A2TYk=
[#@JiaMi@#]7W/3BQwhDCY/wQQ/j2azxCFVvD7nx4MQbBOarX+akziFZIFjh6HFnanI5fD7DRWVOw==
[#@JiaMi@#]RWWAEU9TBrw/aaUIWzxQsqDi9Fr9RN2upJHEgzicwO8hj9VNr/chM8kT5j599tUkFw==
[#@JiaMi@#]/vpPYFi7L2c/T7jLcf0DjAojnxwyNqTe+kXp3hDo1ZK017kHIiRBRJ58v6vDbvQQkA==
[#@JiaMi@#]krh5NJBUlHDdU0JVBB8joH8uYnrL0g/+1SISxZKeLhHGLabSZhqxBz6higr4S8jCytOpMIWzi9HCUUB2F6Pbs8ASxD4n99f474exCiFzTiJwilK5rlSpQPS826HGnQ==
[#@JiaMi@#]l2MbbozUhoQXiA4TwmDde6pxrc8C57asvB9rzLIn4K15HW5Vd019E92ZY+XgofS1nmdHiWbO
[#@JiaMi@#]R5fQCy2wTFmnJBugcT/xJbF+lAwZFWkARETSTy0H3RWSGTphzNpOkChCEF8e2asQd9/D7oy/ZNjvXm7DBg600yf3p7zoVY/Uduh64J5byH4=
[#@JiaMi@#]+L3tJXWiaWJjCjH3YpAfnjy/7ykEVddrR7rVfLb4tEcbpSG8w0QUw4x9Ct0vTgbQY1qmnmMXFC+Q06Dm5C2bNT1q2cBFBnGcVsbEHQ==
[#@JiaMi@#]o+TtboOn4+iMnOs4EbBYWsbIRg7lt/aLTuiLyR0s9t88f/P+ioDR7j9SCQ24wZ5Nbg==
[#@JiaMi@#]YQAtFBbwdxUxuU/EFHGejt3/+kPuhFu8m9QdXBTzibtO2UaQ6YkFAvZaQWL+sD6I8Q==
[#@JiaMi@#]6N2NfDZ3lPlcX8G8BlKZYuGxdZI2CxHSLkeGnpBKKd/4oGbIye9mcKUsb1dwUJzFrEQEwbT5bv+7Pm7RD62f+u79XBGKejqfBwdhAxioF9Z2ZvBHQzyC8xq69E8iwQ==
[#@JiaMi@#]EhNqRac+uW83FGeDrRUNTeHPzt615To38Mi6D5QYF57SPlO2m4tY9ZyeVgH2bqhxzgbmkY4w
[#@JiaMi@#]Vur8PhjN2q0DELnZPYc+VMExkpCkSBJOhybChx47HgbOIHhJibRbVzBu1jrZCUqvfwcmuOv1G9HS8MzngQOoN8bG6m9hlwD7seHfCgM8drU=
[#@JiaMi@#]S2DSM0l+xIoeVOvI8TJeF0DKo1HTGDnc/iuJPCazWxaLuIYuK6bJD8HEmv1O1q6yrDlc1dx5JQ01zhVayEzp+HBjm7LsweqBAKslSyo0e3EQ