List Same Column Multiple Times By Different Names In Sql – Query Examples

List Same Column Multiple Times By Different Names In Sql

In Sql, we can list same column multiple times by differrent name in sql. We must rename the column using as key word.

Examples:

TO DOWNLOAD THE SAMPLE LİBRARY DATABASE CLICK

1) List student name two times in one query.

Result:

2) List all book’s name three times in sql query

 

YOU MAY WANT TO SEE OUR ALL EXAMPLES PAGE, THEN CLICK HERE

 

About the author

admin

Leave a Comment

%d bloggers like this: