I have a host table where I save the platform model. The platform model
can be saved in various ways. For example,
Sun Enterprise 250 (2 x UltraSPARC 164MHz)
Sun Enterprise 250 (2 x UltraSPARC-II 400MHz)
Sun Enterprise 250 (2 x UltraSPARC-II 450MHz)
Sun 250
etc. I can get the count by:
select pl
I am a beginner at SQL and would appreciate any help with a simple
query.
I have two tables:
host
patch
The host table contains details for a particular host (OS, cpus, memory, etc)
and the patch table contains patches installed on that host.
For example:
Host:
hostid hostname