I know how to use a query to show m 1

[NewToProgramming]

I know how to use a query to show me the maximum record, example:
Query.SQL.Add ('Select Max fieldname as whatever from database')
But how would you have the query give you the top 10 of the latest 20 results?
Thank you,
Mark

 

[LucieLastic]

hi

If you're using SQLServer you can do it with

select top 10 max(field) from blah

With other databases you will probably have to restrict it programmatically, for example

i := 1
query.first;
while not query.eof and (i<=10) do
begin
memo.lines.add(query.fields[0].<asWhatever>)
query.next;
inc(i);
end;

lou

 

[NewToProgramming]

and what about the bottom 10 of 20 as well?
Sorry, should have asked both questions at the same time.
Mark

 

[NewToProgramming]

Never mind. I got it to go backwards too. Wasn't too hard to figure out.
Thank you,
Mark

 

[LucieLastic]

...yep, you change your order by to desc.