我将如何获得基于Rowid的最大和最小数量 [英] How Will I Get Maximum And Minimum No. Of The Based Of 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

推荐答案

尝试：

Try:

SELECT * FROM MyTable
WHERE rowid=MAX(rowid) OR rowid=MIN(rowid)

这篇关于我将如何获得基于Rowid的最大和最小数量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！