Click here to Skip to main content
16,019,764 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
CSS
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
Posted

1 solution

Try:
SQL
SELECT * FROM MyTable
WHERE rowid=MAX(rowid) OR rowid=MIN(rowid)
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900