Tech Study

Write a SQL query to get FirstName, Lastname, Scholarship amount from tblStudent and tblScholarship table for all students even if they didn’t get Scolarship

Introduction

Write a SQL query to get FirstName, Lastname, Scholarship amount from tblStudent and tblScholarship table for all students even if they didn’t get Scolarship. I have used Microsoft SQL server 2008 R2 for the following demo.

– tblstudent

StudentId FirstName LastName Admission_fee Admission_date Branch
1 John Smith 1000 2018-06-10 Computer Engineering
2 David Jones 1200 2018-06-20 Civil Engineering
3 Michael Johnson 900 2018-08-15 Chemical Engineering
4 Chris Lee 1500 2018-07-10 Electrical Engineering
5 Mike Brown 1600 2018-09-10 Mechanical Engineering
6 Lisa Smith 1800 2018-07-10 Computer Engineering
7 Mary Smith 1600 2018-06-11 Computer Engineering

– tblScholarship

Student_ref_id Scholarship_Date Scholarship_Amount
1 2018-10-09 100
2 2018-11-10 150
3 2018-12-12 200
4 2019-01-05 100
5 2019-02-25 150
6 2019-03-15 NULL
7 2019-04-23 110
SELECT Firstname, Lastname, Scholarship_Amount
FROM tblStudent A LEFT JOIN tblScholarship B
ON A.StudentId = B.Student_ref_id

Result

Write a SQL query to get FirstName, Lastname, Scholarship amount from tblStudent and tblScholarship table for all students even if they didn't get Scolarship
Write a SQL query to get FirstName, Lastname, Scholarship amount from tblStudent and tblScholarship table for all students even if they didn’t get Scolarship

Taggedlastname)Scholarship amount from tblStudent and tblScholarship table for all students even if they didn't get ScolarshipWrite a SQL query to get FirstName

Java Final keyword

Introduction : java final keyword The final keyword present in Java programming language is generally used for restricting the user. …

Read more

C++ Memory Management: new and delete

C++ Memory Management We know that arrays store contiguous and the same type of memory blocks, so memory is allocated …

Read more