Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

home / developersection / forums / what is an alias command in sql server, where apply alias in the database command?
Ask Question

What is an ALIAS command in SQL Server, where apply alias in the database command?

Ravi Vishwakarma 632 22 Sep 2021

What is an ALIAS command in SQL Server, where apply alias in the database command?

database databasemysqlsql serversql
Updated 22 Sep 2021
Ravi Vishwakarma
Ravi Vishwakarma

Software Developer

Hi, my self Ravi Vishwakarma. I have completed my studies at SPICBB Varanasi. now I completed MCA with 76% form Veer Bahadur Singh Purvanchal University Jaunpur. SWE @ MindStick | Software Engineer | Web Developer | .Net Developer | Web Developer | Backend Engineer | .NET Core Developer

Message

1 Answers

Ashutosh Kumar Verma
Ashutosh Kumar Verma 24 Sep 2021
Report Abuse

SQL Aliases :

SQL aliases are used to give a temporary name to tables or columns in table. It is exist only duration of that query in perform. Alias are used to provide a easier name to table or column of table. An alias is create with use of ‘AS’ keyword.

Syntax :

Alias for column- 

SELECT column_name AS alias_name FROM table_name;

We can also create alias for multiple column in a table. 

SELECT column1 AS alias1, column2 AS alias2 ,… FROM table_name ;

Alias for Table- 

SELECT colum1,column2,… FROM table_name AS alias_name ;

Example :

Lets have a table ‘Customer’,

Ashutosh Kumar Verma

Follow the statement is used alias for table column ‘cust_name’ as ‘name’ and ‘city’ as ‘c’ . 

select cust_name as name, city as c from Customer;

Ashutosh Kumar Verma

The following SQL statement is using alias for a table ‘Customer’ as ‘cust’. 

select cust.cust_name,cust.city,cust.customer_id from Customer as cust;

Ashutosh Kumar Verma

We can also provide aliases to retrieve record from more than one table at a time like below. 

select cust.cust_name,cust.city,cust.customer_id, sale.salesman_id, sale.name 

from Customer as cust,Salesman as sale where cust.salesman_id=sale.salesman_id;

Ashutosh Kumar Verma

We can also provide single alias for two or more columns in a table at a time. In the following statement a alias ‘name’ for column name ‘cust_name’ and ‘city’ in ‘Customer’ table. 

 select customer_id, cust_name+','+city as name from Customer;

Ashutosh Kumar Verma

To give space between alias name use [alias name] in SQL statement. 

select customer_id, cust_name+' , '+city as [name  address] from Customer;

Ashutosh Kumar Verma

In the following statement select a record where customer_id=3007(Brad Davis). By using ‘Customer’ and ‘Salesman’ table and give the alias name as ‘cust’ and ‘sale’ respectively. 

select cust.customer_id, cust.cust_name,sale.salesman_id,sale.name 

from Customer as cust, Salesman as sale 

where cust.cust_name='Brad Davis' AND cust.salesman_id=sale.salesman_id;

Ashutosh Kumar Verma

advertising