Thread: sql query

i want to display the column like dis

id name sal
1 max 20000
2 hitman 40000
3 tom 50000
total 110000

U want to disply like this

1 max 20000
2 hitman 40000
3 tom 50000
total 110000

in an sql assistant.....I think its not possible...uasing a reporting tool we can display

cheers,
bharath

You have to use oracle9i

Try this,Sure it will work

Select * from tablename
group by rollup(id);

you also need to post what is the structure of your actual data.