本文介绍了我将如何获得基于Rowid的最大和最小数量的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
geoid userid date1 time1 latitude longitude Location check_status rowid
10 10224 2014-04-12 9:11 AM 28.441540399999997 77.1012118 Parsvnath Exotica, Sector 53, Gurgaon, Haryana, India NULL 1
11 10224 2014-04-12 9:50 AM 28.441540399999997 77.1012118 Parsvnath Exotica, Sector 53, Gurgaon, Haryana, India NULL 2
12 10224 2014-04-12 9:51 AM 28.441540399999997 77.1012118 Parsvnath Exotica, Sector 53, Gurgaon, Haryana, India NULL 3
13 10224 2014-04-12 9:53 AM 28.441540399999997 77.1012118 Parsvnath Exotica, Sector 53, Gurgaon, Haryana, India NULL 4
14 48324 2014-04-12 10:41 AM 28.441540399999997 77.1012118 Parsvnath Exotica, Sector 53, Gurgaon, Haryana, India NULL 1
15 48324 2014-04-12 11:44 AM 28.4410165 77.10038209999999 Parsvnath Exotica, Sector 53, Gurgaon, Haryana, India NULL 1
16 48324 2014-04-12 11:46 AM 28.4410165 77.10038209999999 Parsvnath Exotica, Sector 53, Gurgaon, Haryana, India NULL 2
17 48324 2014-04-12 11:47 AM 28.4410165 77.10038209999999 Parsvnath Exotica, Sector 53, Gurgaon, Haryana, India NULL 3
18 48324 2014-04-12 11:48 AM 28.4410165 77.10038209999999 Parsvnath Exotica, Sector 53, Gurgaon, Haryana, India NULL 4
19 48324 2014-04-12 11:50 AM 28.4410165 77.10038209999999 Parsvnath Exotica, Sector 53, Gurgaon, Haryana, India NULL 5
20 48324 2014-04-12 11:51 AM 28.4410165 77.10038209999999 Parsvnath Exotica, Sector 53, Gurgaon, Haryana, India NULL 6推荐答案
SELECT * FROM MyTable
WHERE rowid=MAX(rowid) OR rowid=MIN(rowid)
这篇关于我将如何获得基于Rowid的最大和最小数量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！