SQL Querry加入.. !!!!

问题描述

您好，先生，

我在Student_Details表中有名字，姓氏.

我想将这两个字段显示为一个字段.

(例如:Prasad Guduri)

别名全名.

怎么样?

请帮助我..... !!!!

谢谢N问候

Prasad Guduri

Hi Sir,

I have first_name, last_name in table Student_Details.

i want to display those two fields as one field.

(Exapmle: Prasad Guduri )

with alias name Full Name.

How ?

Please help me.....!!!!

Thanks N Regards

Prasad Guduri

推荐答案

SELECT FirstName + ' ' + LastName  AS FullName
FROM YourTable

这篇关于SQL Querry加入.. !!!!的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！