Home » SQL & PL/SQL » SQL & PL/SQL » sql query
sql query [message #7707] Wed, 02 July 2003 03:30 Go to next message
Sijo
Messages: 2
Registered: December 2001
Junior Member
SQL query for retrieving the position of the maximum value in a table.

Report message to a moderator

Re: sql query [message #7708 is a reply to message #7707] Wed, 02 July 2003 05:25 Go to previous message
Angelo
Messages: 16
Registered: November 2001
Junior Member
What do you mean by "the position"?

Have a look at the MAX, RANK and DENSE_RANK functions, these may help you.

Report message to a moderator

Previous Topic: altering column places in the table
Next Topic: Database Trigger Help
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 16:35:21 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.