CChandanaintechblogchandana.hashnode.dev·Jan 17, 2024 · 3 min readSQL: Structured Query Language- Part4 #sqlzerotoheroSQL- UNION The UNION operator is like a tool that lets you bring together the results of two or more SELECT statements. Here are the rules for using UNION: Each SELECT statement involved must have the same number of columns. The columns must be...00
CChandanaintechblogchandana.hashnode.dev·Jan 16, 2024 · 3 min readUseful Docker Commandslist of docker commands docker run - run a container from an imagedocker pull - pull an image from a registrydocker push - push an image to a registrydocker build - build an image from a Dockerfiledocker ps - list running containersdocker stop - stop...00
CChandanaintechblogchandana.hashnode.dev·Jan 15, 2024 · 5 min readSQL: Structured Query Language- Part3SQL- GROUP BY The GROUP BY statement aggregates rows with identical values, summarizing them into groups, such as "determine the count of customers in each country." Typically, the GROUP BY statement is paired with aggregate functions (COUNT(), MA...00
CChandanaintechblogchandana.hashnode.dev·Jan 4, 2024 · 3 min readSQL: Structured Query Language- Part2SQL- ORDER BY The ORDER BY keyword is used to sort rows based on a column value, in ascending or descending order. We use ASC to sort in ascending order and DESC to sort in descending order.If we leave it blank, then ORDER BY uses ASC by default. ...00
CChandanaintechblogchandana.hashnode.dev·Jan 4, 2024 · 4 min readSQL: Structured Query Language- Part1SQL is an abbreviation for Structured Query Language. SQL allows you to connect to and manipulate databases. SQL was adopted as an American National Standards Institute (ANSI) standard in 1986 and as an International Organization for Standardization ...00