Select data on max value
Closed
rahimisoft
Posts
6
Registration date
Sunday October 31, 2010
Status
Member
Last seen
March 28, 2011
-
Mar 28, 2011 at 01:58 PM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Mar 29, 2011 at 01:20 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Mar 29, 2011 at 01:20 AM
Hello,
i have a simple question but i coudnt solve it!
i have a query by named query1 that have a column ((testname)) by various numbers between 1 and 12.
i want to design a select query to select datas where data=max(testname)
note : this clolumn (testname) is an expression column
thanks alot
i have a simple question but i coudnt solve it!
i have a query by named query1 that have a column ((testname)) by various numbers between 1 and 12.
i want to design a select query to select datas where data=max(testname)
note : this clolumn (testname) is an expression column
thanks alot
Related:
- Select data on max value
- Vba select case like - Guide
- Free fire max download - Download - Battle royale
- Tmobile data check - Guide
- Max active checking torrents - Guide
- Max repel cheat code fire red - Guide
1 response
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Mar 29, 2011 at 01:20 AM
Mar 29, 2011 at 01:20 AM
if you want to a particular value from a coloumn (its on column B) with respect to maximum value (test name suppose it is in column E). you can use the function.
=INDEX(B:B,MATCH(MAX(E:E),E:E,0)).
=INDEX(B:B,MATCH(MAX(E:E),E:E,0)).
