Standards Track [Page 2]. RFC 6298 Computing TCP's Retransmission Timer June 2011.
Затем управление передается оператору, следующему End Select.Control then passes to the statement following End Select.
SELECT CASE WHEN FRUIT = 'A' THEN 'APPLE' WHEN FRUIT = 'B' THEN 'BANANA' END AS FRUIT FROM FRUIT_TABLE; As a reminder remember; no assignment is performed the value becomes the column contents. (If you wanted to assign that to a variable you would put it before the...
SELECT Store_Name, CASE Store_Name WHEN 'Los Angeles' THEN Sales * 2 WHEN 'San Diego' THEN Sales * 1.5 ELSE Sales END "New Sales", Txn_Date FROM Store_Information
Then you can easily sort non-NULLs values in ascending/descending order or the NULL values in first or last position.
SELECT ID, nom, (CASE etat WHEN 1 THEN prix*1.2 ELSE 0 END) AS "Prix produit TTC" FROM jeu_donnee.
Sometimes it's necessary to translate stored values (or values to be stored) from one representation to another. Suppose there is a column status with legal values from 0 to 9 but the end-users should receive strings which explain the meaning of the numeric values in short, eg.: 'ordered', 'delivered'...
Report a problem or mistake on this page. Please select all that apply: A link, button or video is not working. It has a spelling mistake.
Бесплатный сервис Google позволяет мгновенно переводить слова, фразы и веб-страницы с английского на более чем 100 языков и обратно.
If they all are numeric, then the database will determine which argument has the highest numeric