ALIASING
Aliasing in SQL means giving a temporary name to a column or table in a query to make results clearer or queries shorter and easier to read.
Syntax
SELECT column_name AS alias_name
FROM table_name;
#DataAnalytics#Datafam#viralpost#sqldatabases
Updating and Deleting data in SQL
- Updating data in SQL is done with the UPDATE statement.
It lets you modify one or more rows in a table.
- Deleting data in SQL is done mainly with the DELETE, TRUNCATE, and sometimes DROP commands.
#datafam#DataAnalytics#SqL#viralvideo
Can you call a Procedure in a `SELECT` statement?
No.
Here is why:
Procedures are for Actions
Functions are for Values
Think of it this way:
- To DO something? Procedure
- To GET something? Function
Did you know? Let me know!
#sqldatabases#Tech