SQLTeam.com | Weblogs | Forums

Grading

mysql

#1

I have been trying to solve this query on wherein there is a table which include the name,marks and Id and i want to insert another columns (Grades ) based on the marks scorded.

Marks Grades

90 10
<89 &>80 9

and so on
Based on the grades being assigned i want Write null in place of the names of students whose grades is less than 8 but the rest of the table remains same.


#2

Your post was flagged as spam because of the URL in the title, which you have now changed.

But Admin will have to un-release the post ...

I haven't checked the linked URL, but I see you have marked the post as MYSQL. This is a Microsoft SQL Server forum, so it is possible that folk here won't know the answer to a MYSQL question, and you might want to ask on a MYSQL forum (assuming your question is actually impacted by the subtlety of syntax, rather than just a generic SQL question)