SQL Query

[jimmy80]

Hi

I'm trying to write an SQL query in Oracle 8i which retrieves a number of columns. In addition I want to retrieve 3 benchmark columns (the information in each varies however the rest of the data is the same) The query I have written at the moment returns the data in 3 seperate rows... I want the all the data return in 1 row.. Is this possible to do?

Thanks for your help.

 

[Turkbear]

Hi, give us an example of your current Sql query and we can see what to modify..

 

[fmorel]

When you have multiple rows and you want 1 row, you have to use grouping and aggregate functions, eg GROUP BY and sum(), max(), min() ...