It depends on what you mean by "highest", but assuming you mean lexigraphically highest, this would work:
SELECT MAX(volume_name) FROM libvolumes WHERE library_name='foo' On Thu, Dec 11, 2014 at 03:41:23PM +0000, Loon, EJ van (ITOPT3) - KLM wrote: > Hi TSM-ers! > Does anybody know a SQL statement to retrieve the highest volume label of all > tapes in a library? Is it possible with one single SQL query? > Thanks for any help in advance! -- -- Skylar Thompson ([email protected]) -- Genome Sciences Department, System Administrator -- Foege Building S046, (206)-685-7354 -- University of Washington School of Medicine
