db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Legolas Woodland <legola...@gmail.com>
Subject A SQL question , how to show calculated fields in Rows not in columns
Date Wed, 08 Feb 2006 12:44:58 GMT
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.

View raw message