How to find the age of each employee and store that in new column #sql #sqlqueries #coding #shorts

How to find the age of each employee and store that in new column #sql #sqlqueries #coding #shorts #sqlinterview #programming #youtubeshorts

[sigitasstumbras]

Under normal circumstances you would create a view with a calculated column

[longshin]

Nice, but in reality might not work. When tables have millions records that function not have index support then really really slow -> die

[srinivasaguptamaram]

Show it as a view... Adding an age column is not good since it is dynamic and changes every year..

[YogiNotTheBear]

This wouldn’t give you exact age though. You need to apply some case statements to address months difference. For ex if current month is greater than DOB month thn you need to subtract 1 from the year and so with date as well.

[Tech-wntp]

sql complex queries are chatgpt favourite game.

[C.K.Arun.]

in this alter statement when creating a new column name called AGE datatype is not mention. here what would be the datatype of the column AGE here ?

[omroyy]

Bro now how to aad Data in new added column only??

[dravid]

Hi, can we do this without altering the table?

[bas-yahi-dekhna-bacha-tha]

Does my original CSV file also get altered or I have to save the new table again to keep the changes.

[Rajag-icxt]

How come it accepted without data type need to try and check

[nathnolt]

Are the values in this column reactive?