Wear a mask
Maintain Social Distancing
Stay at Home
Sanitize yourself
Get your Vaccination Done.
Check out the new machine learning project which is used for heart disease prediction. Click on the google colab link given below:
https://colab.research.google.com/drive/1bzOnr419MW769ped-VOKaJ9PI81jmMax?usp=sharing
Link for the dataset is posted below.
https://1drv.ms/u/s!AgSfTLYCxbCxkGhCggr1I49LLWh0
The Insert Into Select statement
The INSERT INTO SELECT statement copies data from one table and inserts it into another table. This statement requires that the data types in source and target tables matches. The existing records in the target table are unaffected. SYNTAX One can also copy only the names of the specific columns that he she wants in…
EXISTS, ANY, ALL
EXISTS: The EXISTS operator is used to check the existence of record in the subquery. It returns TRUE if the subquery returns one or more records. SYNTAX: ANY & ALL : These operators allow you to perform a comparison between a single column value and a range of other values. ANY operator: returns a Boolean value…
GROUP BY & HAVING
GROUP BY The GROUP BY statement groups rows that have the same values into summary rows. This statement is often used with aggregate functions like COUNT(), MAX() , MIN() , SUM() , AVG() to group the result-set by one or more columns. Syntax: HAVING The HAVING clause was added to SQL because the WHERE keyword…
Coding Blogs 