Write a query to find out the studentname who has not received any scholarship amount, and display 0 in front of his name.

A PHP Error was encountered

Severity: 8192

Message: str_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated

Filename: libraries/Filtered_db.php

Line Number: 23

Write a query to find out the studentname who has not received any scholarship amount, and display 0 in front of his name.

YasminRadwan26

Save to bookmark

2022-05-13

235

Write a query to find out the studentname who has not received any scholarship amount, and display 0 in front of his name.

Database, Sql programming, Interview questions, Database Interview-questions, Sql programming Interview-questions,

All Answers

YasminRadwan26

2022-05-13

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

Select Firstname, ISNULL(Scholarship_Amount, 0) As [Scholarship Amount]
from tblStudent A Left Outer Join [tblScholarship] B on 
A.StudentId = B.Student_ref_id where Scholarship_Amount is null

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

total answers (1)

A PHP Error was encountered

Write a query to find out the studentname who has not received any scholarship amount, and display 0 in front of his name.

All Answers

This question belongs to these collections

Similar questions

need a help?

find thousands of online teachers now