Q:

Select FirstName, Lastname, Scholarship amount from tblStudent and tblScholarship table for all students even if they didn’t get Scolarship amount and set Scolarship amount as 0 for those students who didn’t get Scolarship amount.

YasminRadwan26
Save to bookmark
|
2022-05-13
|
  241 
0

Select FirstName, Lastname, Scholarship amount from tblStudent and tblScholarship table for all students even if they didn’t get Scolarship amount and set Scolarship amount as 0 for those students who didn’t get Scolarship amount.

Database, Sql programming, Interview questions, Database Interview-questions, Sql programming Interview-questions,
login and add your own answer to this question

All Answers

YasminRadwan26
2022-05-13
need an explanation for this answer? contact us directly to get an explanation for this answer 

Select Firstname, Lastname, ISNULL(Scholarship_Amount,0) from tblStudent a left join
tblScholarship B on A.StudentId = B.Student_ref_id

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

This question belongs to these collections

Similar questions

need a help?

find thousands of online teachers now