By specifying multiple columns in GROUP BY clause we can split the result set into smaller groups. The more columns specified in GROUP BY clause, the smaller the groups will be.Examplemysql> Select designation, YEAR(Doj), count(*) from employees GROUP BY designation, YEAR(DoJ); +-------------+-----------+----------+ | designation | YEAR(Doj) | count(*) | ... Read More

We cannot use = (comparison operator) because we know that NULL is not a value. If we want to get the rows with NULL from a table then we need to use IS NULL operator in MySQL query. Following example using the data from ‘employee’ table will exhibit it −Examplemysql> ... Read More

We can find a string of specified pattern within another string by using LIKE operator along with WILDCARDS.SyntaxLIKE specific_patternSpecific_pattern is the pattern of string we want to find out within another string.ExampleSuppose we have a table named ‘student’ having names of the students and we want to get the details ... Read More

The base must be greater than 2 and less than 36 i.e. the lower limit of a base is 2 and the upper limit is 36. It is applied to both from_base and to_base values. If in case we provide out of limit values of the base then MySQL returns ... Read More

To set marker outside of the box containing the bullet points, use the list-style-position property with the value outside.Example The outside value means if the text goes onto a second line, the text will be aligned with the start of the first line                     ... Read More

The list-style-position property indicates whether the marker should appear inside or outside of the box containing the bullet points. It can have one the two valuesValueDescriptionnoneNAinsideIf the text goes onto a second line, the text will wrap underneath the marker. It will also appear indented to where the text would ... Read More

The border-bottom-style property changes the style of bottom border. You can try to run the following code to implement the border-bottom-style property:Example                            This is demo content          

The border-top-color changes the color of top border. You can try to run the following code to implement the border-top-color property:Example                    p.demo {             border:3px solid;             border-top-color:#FF0000;          }                              Example showing border top color property          

The border-top-width property changes the width of top border. You can try to run the following code to implement border-top-width property:Example                            This is demo content.          

The border-width property changes the color of the right border.ExampleYou can try to run the following code to implement the border-width property:                            Example showing border width and style