325

It is possible, for example in the context of a competition, that we are looking to find out what are the 5 best scores preceding the one I just made. To do it in SQL, although a little tricky, it is not too complicated. The 5 before me Select FROM scores WHERE score from api_scores … Read more

When it is necessary to have a predefined order in a query, it is possible to change the order of the items by using a CASE in the ORDER BY. In this example id 12 must appear before id 2. Select FROM channel ORDER BY ( Box WHEN id – 1 THEN 1 WHEN id … Read more

In order for one CSS attribute to take precedence over another, for example when an item is defined by two classes, it is possible to use the !important option. For example: CSS: . style1 background-color: #38c8ff; } . style2 background-color: #ffffff!important; } The background will ultimately be white