SQLTeam.com | Weblogs | Forums




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.


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)