Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raokikun
Starting Member
8 Posts |
 Posted - 2011-08-29 : 02:48:05
|
this are the details im gonna use
P_ID (a primary key)
student number
full name or firstname,lastname? (which is better)
year level
semester
course
subject code
subject description
grade
remarks
my system would be aimed to.. display the current grade of the student for example he is 4thyear and in semester 2 right now.
then there will be a button or any step that would display all his grade starting from 1st year sem1,sem2 up to his present grade
is it possible. can anyone help me? it will be a great help
feel free to give hints,tips and advice regarding database making
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-29 : 07:21:30
|
something like
select *
from
(
select row_Number() over (partition by fullname,course order by semester desc) as seq,columns..
from table
)t
order by fullname,course,seq
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
 |
|
|
jassi.singh
Posting Yak Master
122 Posts |
Posted - 2011-10-08 : 09:48:32
|
Hi, You can make a simple modification in previous message query i.e. instead of including fullname in partition by clause use studentnumber column of your table
Please mark answer as accepted if it helped you.
Thanks,
Jassi Singh |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-08 : 09:57:27
|
quote:
Originally posted by jassi.singh
Hi, You can make a simple modification in previous message query i.e. instead of including fullname in partition by clause use studentnumber column of your table
Please mark answer as accepted if it helped you.
Thanks,
Jassi Singh
what difference does it make?
Also whats the purpose of opening a thread now after almost 2 months?
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
|
|
|
connecting multiple table records and display on o