How to Select Record with extra text

Accepted answer

Try this

This will show the result you are looking for.

+2

thanks to all of you sir...

+1

Why manipulating data if not exists, its better to insert than manipulating it.anyway you can do this as below

+2

i want to fetch record like as below image.

their is fixed record in table 4. but i want to display 5th record as "Other Dept" in the last. with name Other Dept

+1

Select EmpId, EmpName,EmpDept, 'yourData' as OtherDept from Tablename

+1