Thank you so much madam soo easy for anyone can understand hatsa of for ur explaination I feel so happy I found out good channel to learn SQL with clear explanation soo thank you
Hi Saloni, thanks for making this video. I have a doubt please help me out. I have birthdate column in 06-04-1991, 6/29/1984 (datatype TEXT). So I replace the ' / ' with ' - ' . And I want it in default Format( '1991-06-04' , '1984-06-29')??
Saloni can you please tell me for POSTGRESQL and SQL Server what will be the following functions ?
Select id,name,DATESUB( dob, INTERVAL 3 YEAR) as updated_date_of_birth from employee
Great Explanation in the correct order!
Thank you so much madam soo easy for anyone can understand hatsa of for ur explaination I feel so happy I found out good channel to learn SQL with clear explanation soo thank you
Thank you for your kind feedback! I'm glad you found the explanation helpful. Happy learning! 😊
SELECT id , name , DATESUB(dob , INTERVAL 3 YEAR) AS updated _date _of _birth from EMPLOYEE .
Select id,name, date_sub(dob,interval 3, Year) as updated_date_of_birth from employee;
Very real time use video❤
11:09
select id, name, dob,, date_sub(dob, interval 3 year) as updated_date_of_birth from employee;
Thank you 🙏
Thank you so much for this video
You are welcome!
Select id, name, subdate(dob, interval 3 year) as updated_date_of_birth from employee;
Finished watching
In My SQL how to delete duplicate rows inside the table without unique identifier...?
My table name: accounts
My column names: username and firstname
Thanks for the video
Good job 👌👌👌👌
Thanks
Good video 👍👍
Thanks for the visit
You are explaining in my sql
select id,name, date_sub(dob,interval 3 years) as update_date_of_birth from employees
Identify details of all the morning flights (morning means between 6AM to 11 AM, using flights table)?
please help me
Hi
Date, month ,year combination using SQL query add and subtract how write the formula
Hi Saloni i want to subtract date from 2 different columns and want the output in days but it is not working kindly suggest
Hi Saloni, thanks for making this video. I have a doubt please help me out. I have birthdate column in 06-04-1991, 6/29/1984 (datatype TEXT). So I replace the ' / ' with ' - ' . And I want it in default Format( '1991-06-04' , '1984-06-29')??
we need to more examples and more explanation your explanation way good but we need some more stuff in the subject
age function not use in mysql.pls tell another function use in mysql
SELECT ID,NAME,DOB,SUBDATE(DOB,INTERVAL,3 YEAR) AS UPDATED_DATE_OF_BIRTH FROM EMPLOYEE;
There should not be a comma after interval
aapka page not found kyu aa rha hai jisme data store hai
codeera.netlify.app/wp-content/uploads/2023/11/INSERT-Records-in-Employees-Table.pdf
Sorry for the trouble
this one was difficult for me ngl i over thought the answers to the practice questions
Stop saying so guys....it is so irritating 🥶🤯🤬😡
Use something better...like dear learners or just say developer or say we or you😊