Q:

Select FirstName, Lastname, Scholarship amount from tblStudent and tblScholarship table for those students who got Scolarship amount greater than 1200.

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

Select FirstName, Lastname, Scholarship amount from tblStudent and tblScholarship table for those students who got Scolarship amount greater than 1200.

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, Scholarship_Amount from tblStudent A Inner join tblScholarship 
B on A.StudentId = B.Student_ref_id and Scholarship_Amount > 1200

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