SQL Tutorial in Oracle - 5 Column Alias with Order By

preview_player
Показать описание
SQL aliases are used to give a database table, or a column in a table, a temporary name.

Follow on Facebook:

Subscribe to our other channel:
Telusko Hindi :
Рекомендации по теме
Комментарии
Автор

From --->Where---> Select--> Order By... Perfectly explained... Really appreciate it for having made it simple...

evanexcel
Автор

Awesome explanation bro :) keep up the good work

prashanth
Автор

Assuming we having a medication table where we need to find the minimum cost and give the alias name as lowest_cost
This query works perfect fine
select min(cost) lowest_cost from medication
Result:
LOWEST_COUNT
75.00

This doesn't change the name of the column
select cost lowest_cost from medication where cost in (select min(cost) from medication)
Result:
COST
75.00
Can i Know as to why there is a difference?

taniamendonca
Автор

Sir can we use as for alias
ie: select sname as studentname from student ; 👆is the above query correct

vinaykumarjk
join shbcf.ru