Select Query which returns the single row

sameena · New User Joined: 27 Nov 2006 Posts: 6 Location: india

Hi,

assume there is a table student with Fields subject name and marks
s 10
s 20
s 30

the number of rows in the table may vary...
now i want an sql query which returns the single row which contain s 10 20 30 i.e only single row consist of all the marks for the subjest 's'

William Thompson · Posted: Tue Jan 23, 2007 6:45 pm

Rather unclear, just select columns where ____? Fill in the blank with the where clause.

dineshness · Posted: Wed Jan 24, 2007 12:05 am

I guess what you are asking for is
a query to select values from one or more columns and
return it as one row, which i think is impossible.

For some reason, if you want this way
in your program to avoid the usage of cursor,
you can create a temporary table having one row with so many columns and (call a stored procedure) or (code sqls in your program) to update that temporary table with latest values. And then select it from that temporary table.

DavidatK · Posted: Wed Jan 24, 2007 2:35 am

Sameena,

What is the maximum number of scores a student can have?

jinal_mca · Posted: Wed Jan 24, 2007 12:30 pm

Dear ur question is not clear ..
still i think if single row in ans u want u can do addition of all the marks with the help of aggregate function...
cya