Select query help!

  • Thread starter Thread starter Select query help!
  • Start date Start date
S

Select query help!

Hi people,

Pls help to select the following data.
Tha table has subnet, address, serail# and model columns.
I need to select the data where various addresses belong
to the same subnet. I also need to include serial and
model fields.

Thanks a million,

Serg
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Not quite sure what you want, but, try this:

SELECT subnet, address, [serial#], model
FROM table_name
ORDER BY subnet, address

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQS0D6YechKqOuFEgEQIk8wCgup1UgwiYbuax3MU9/JpusDCLX5wAnRDD
CVV3JFK65zZWTAAPnp68ye0l
=n0qx
-----END PGP SIGNATURE-----
 
That is not quite what I need.
See, a network subnet could be on the same address.
Sometimes, various addresses share the same subnet. I
would like to see the report where various addresses share
the same subnet, inluding serial and model fields.

Thank you,
-----Original Message-----
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Not quite sure what you want, but, try this:

SELECT subnet, address, [serial#], model
FROM table_name
ORDER BY subnet, address

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQS0D6YechKqOuFEgEQIk8wCgup1UgwiYbuax3MU9/JpusDCLX5 wAnRDD
CVV3JFK65zZWTAAPnp68ye0l
=n0qx
-----END PGP SIGNATURE-----

Hi people,

Pls help to select the following data.
Tha table has subnet, address, serail# and model columns.
I need to select the data where various addresses belong
to the same subnet. I also need to include serial and
model fields.
Click to expand...

.
Click to expand...
 
Back
Top