SQL & Counting
2015-10-04 17:33:43
Can anyone tell me how to incorporate a count parameter into SQL statements
For example i can execute the following SQL statements:
select node_name,volume_name,stgpool_name from volumeusage where
node_name='$1'
But I would like a count at the end to tell me the number of volumes in
question
Thanks in advance
> John Doherty. Tel: +44 (0) 141 275 7793
> Fax: +44 (0) 141 275 9199
> Email: JDohe1 AT Anfis.co DOT uk
>
> Technical Specialist, Storage Management L02S
>
> Email communications are not necessarily secure and may be intercepted or
> changed after they are sent. Abbey National Financial and Investment
> Services does not accept liability for any such changes. If you wish to
> confirm the origin or content of this communication, please contact the
> sender using an alternative means of communication. This communication
> does not create or modify any contract. If you are not the intended
> recipient of this communication you should destroy it without copying,
> disclosing or otherwise using its contents. Please notify the sender
> immediately of the error.
>
> ABBEY NATIONAL FINANCIAL AND INVESTMENT SERVICES plc
> Registered Office Abbey National House 287 St Vincent Street
> Glasgow G2 5NB United Kingdom Registered in Scotland No 159852
>
|
|
|