by WEB111 » Wed, 06 Nov 2002 05:34:02
I have a table in which each record has a variable valued integer field. I
don't know what record has the largest value. Can one of you provide me
with a simple SQL query to find and return the maximum value in this field.
I just had a thought. If I specify this integer field as an ascending
index, is there a simple SQL query that would return the last record in the
index, thus providing me with the largest value.
Thanx,
Bill
by Anith Se » Wed, 06 Nov 2002 05:35:57
SELECT *
FROM yourTable
WHERE yourintCol = (SELECT MAX(yourintCol)
FROM yourTable)
--
- Anith
1. Auto Increment key value retrieval upon insert?
How do I retrieve the value of an auto-increment key column in microsoft SQL
server at the same time I perform an Insert?
Thank you, Brian
2. Developing an Database app. WHITOUT using the DataControl??
3. Cookie value retrieval in xsql
5. HELP NEEDED FOR RETRIEVAL OF DECIMAL VALUES USING DBLIBRARY
7. Adding derived value fields to a DataGrid and URL file retrieval
9. How to Get The second maximum value in given table
10. SQL - Query to get a maximum value
11. >> to query for maximum value
12. maximum value withing a group