Last payment is also a bigger payment

How to create such a query?
Please enter example here :SELECT * FROM TargetBleigh.Mind
seriously,
please let us have more information on what you are trying to acheive.
Is this meant to be a constraint, or a selection filter?
Mr Tea
"TargetBleigh" <ddsd*f.com> wrote in message
news:8a6dnU4VMNCDfYvfRVn-ug@.comcast.com...
> How to create such a query?
> Please enter example here :
>
>|||SELECTION FILTER
THANKS!|||Please read your specs, since we cannot read your mind. If you have a
series of paymetns of different sizes, then you can model each payment
coupon as a single row in a table, with a due date, actual payment
date, etc.|||This is meant to be a query. Not a row in a table, or a restraint.
That is why I used the word "query"|||Here's your query:
SELECT MAX(payment)
FROM table1
Enjoy
"TargetBleigh" <ddsd*f.com> wrote in message
news:nKydnc9MvZvOe4rfRVn-uw@.comcast.com...
> This is meant to be a query. Not a row in a table, or a restraint.
> That is why I used the word "query"
>
>|||That is great. I hope you use that on your resume.
Right at the top.|||Your "specification" is too vague for anyone to give you much help. The
following article explains the best way to get help with your problem
in this group. Please take the time to read it and follow the advice.
The more information you can give the better chance you have of getting
an accurate and useful response.
http://www.aspfaq.com/etiquette.asp?id=5006
David Portas
SQL Server MVP
--|||I don't see how there could be more than one theory about what I meant by my
post.
I need a query that returns all records where the last payment is also the
biggest payment in a given set.
I could jump thru all kinds of hoops including posting data and DDL, but
come on - wouldn't it be easier for those of you who want to help for you
to just imagine a table with dates and dollars?
Do you really need someone to explain that part to you?
Do you absolutely have to think that way?
Please think harder, or at least don't obstruct my thread with answers that
are not answers.
Thanks.|||This is a free forum where people voluntarily give their time to help
others. If you aren't prepared to "jump through a few hoops" then why
should anyone else? No matter. Your responses have probably guaranteed
that everyone will pass this one by anyway.
David Portas
SQL Server MVP
--