db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <Knut.Hat...@Sun.COM>
Subject Re: A SQL question , how to show calculated fields in Rows not in columns
Date Wed, 08 Feb 2006 13:09:42 GMT
Legolas Woodland <legolas.w@gmail.com> writes:

> Hi
> Thank you for reading my post.
> imagine that i have :
> select count(userID) ,count (siteID) from users,websites
>
> it will show one record that contain two columns , each column
> represent one of the count value
> now i want to show two record with one column , indeed i need this to
> pass the query to a charting system . the chart will just use first
> column of each rows.
> so i need to have two rows with one column to use that charting system.

You could try this SQL statement:

SELECT COUNT(userID) FROM users UNION SELECT COUNT(siteID) FROM websites

-- 
Knut Anders


Mime
View raw message