Search results
SQL is a standard language for storing, manipulating and retrieving data in databases. Our SQL tutorial will teach you how to use SQL in: MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems. Start learning SQL now ».
1 cze 2021 · Fetch all names that start with any letter followed by 'atherine': SELECT name FROM names WHERE name LIKE '_atherine'; Fetch all names that end with 'a': SELECT name FROM names WHERE name LIKE '%a'; USEFUL FUNCTIONS. Get the count of characters in a string: SELECT LENGTH('LearnSQL.com');-- result: 12 Convert all letters to lowercase: SELECT ...
This document contains a 15 question quiz on SQL and database programming concepts. The questions cover topics like SQL statements, logical operators, comparison operators, single vs multi-row functions, sorting query results, and limiting records returned. The correct answers to each multiple choice question are indicated. Copyright:
This quiz covers SQL concepts like single and multi-row functions, clauses order, sorting, and comparisons. It contains multiple choice questions testing understanding of SELECT statements, WHERE clauses, ORDER BY clauses, and functions like COUNT, MAX, MIN, and AVG.
17 wrz 2024 · This article presents 12 SQL functions practice questions – with solutions and detailed explanations – that will help you solidify your SQL knowledge. Practicing SQL is important if you want to improve your skills.
1 cze 2021 · Standard SQL Functions Cheat Sheet. TEXT FUNCTIONS. CONCATENATION. Use the || operator to concatenate two strings: SELECT 'Hi ' || 'there!'; -- result: Hi there! Remember that you can concatenate only character strings using. ||. Use this trick for numbers: SELECT '' || 4 || 2; -- result: 42.
Find the names of all employees in the database who live in the same cities as the companies for which they work. select e.employee-name from employee e, works w, company c where e.employee-name = w.employee-name and e.city = c.city and w.company-name = c.company-name.
