List of SQL Query questions on Top, Union, admission fees and Group by questions

Write a SQL query to get firstname from tblstudent with Hello prefix

by

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

Write a SQL query to get firstname from tblstudent with Hello prefix
Write a SQL query to get firstname from tblstudent with Hello prefix

Leave a Comment