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

 

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: