Introduction

Write a SQL query to get firstname from tblstudent with Hello prefix. I have used Microsoft SQL server 2008 R2 for the following demo.

SELECT 'Hello ' + firstname
FROM tblStudent

Result