Go Top SKIP recount()/2 Paul Newton
-----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Allen Sent: 15 April 2014 09:24 To: [email protected] Subject: halfway down a set order Hi Foxgang I am going round the bend with this. Situation. I have a file with dates in (datetime). The dates are not in order, and have a couple of idiots inputs including a year 2210 one plus a jan 2013 when it should be jan 2014. Anyway most are good and in a range. So what I want to do is set the order to the date (actually a datetime fields) ok no problem. Now I want to see what's halfway down. But.... Goto recount()/2 takes me to halfway down the original order which could be an early date (and is in the file I am trying to sort out). So the question is how do I find the halfway point in an ordered table. In other words in this case, halfway down the datetime field. No good looking at min and max as due to the idiot input of 2210 it turns out to be 2107. I cannot assume dates as these files are ongoing. I've got over it with this by select distinct (datetime) order by (datetime) and going halfway but I am curious how halfway down an ordered table can be achieved Al [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
