I want to write a query for students name with * for just passed, ** who got 60%>= and =75%

Question

I want to write a query for students name with * for just passed, ** who got 60%>= and =75%

pankaj.srivastav

Newbie

Points: 3
More actions
June 15, 2009 at 11:47 pm

#103761

Hello,
Please help me to write a query of students exams result.
I want place a * with students got >=40 and <60 percent marks.
I want place a ** with students got >=60 and <75 percent marks.
I want place a *** with students got >=75 percent marks.
Example
Student Name Marks
Mr. A* 45
Mr. B** 67
Mr. C*** 78
Mr. D 35
Please advice as early as possible.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

ps. One Orange Chip Points: 29422 More actions · Answer 1

pankaj.srivastav (6/15/2009)
Hello,
Please help me to write a query of students exams result.
I want place a * with students got >=40 and =60 and =75 percent marks.
Example
Student Name Marks
Mr. A* 45
Mr. B** 67
Mr. C*** 78
Mr. D 35
Please advice as early as possible.

select Stu_name=

case

When marks>=40 and marks=60 and marks=75 then stu_name+'***'

else stu_name

END,

marks from Student_Table

Also go through http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/URL%5D if you need better assistance.

Pradeep Singh

hi_abhay78 SSCertifiable Points: 6265 More actions · Answer 2

Give me the table structure ....

Abhay Chaudhary
Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)

hi_abhay78 SSCertifiable Points: 6265 More actions · Answer 3

You got the answer ....:-)

I was thinking it other way sa if you need to add stars to marks ...

But still if you need it i have copied the small repro below using cast ..

might or might not help but will add to your knowledge ..

declare @marks-2 int

declare @stars varchar (3)

set @marks-2 = 40

set @stars='***'

select cast(@marks as varchar(3)) + @stars

Abhay Chaudhary
Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)

balars_2000 Right there with Babe Points: 717 More actions · Answer 4

Hi,

Use CASE expression within SELECT statement to get your desired result.

cheers