Search results
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 » Examples in Each Chapter
This document contains a 15 question quiz on database programming concepts and functions. The questions cover topics like date functions, number functions, string functions, and SQL statements. Example questions include identifying functions that add months to a date, return the current date, concatenate strings, and format values.
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.
22 paź 2024 · This SQL quiz covers various topics like SQL basics, CRUD operations, operators, aggregation functions, constraints, joins, indexes, transactions, and query-based scenarios. We've included multiple-choice questions, fill-in-the-blank questions, and interactive coding challenges to keep things interesting and challenging.
This document contains a quiz on SQL concepts with 15 multiple choice questions. Key points covered include: - Comparison operators like =, <, >, BETWEEN, IN, LIKE and NULL - Logical operators like AND and OR - Pattern matching with % and _ - Distinct vs non-distinct results - Range queries and concatenation - Case sensitivity of data types
18 sty 2024 · Practice basic SQL – writing SELECT queries, joining multiple tables, using aggregate functions, and working with GROUP BY – for free with these 18 beginner-friendly exercises. Solutions and explanations included!
1 cze 2021 · Remember that you can concatenate only character strings using ||. Use this trick for numbers: SELECT '' || 4 || 2; -- result: 42. Some databases implement non-standard solutions for concatenating strings like CONCAT() or CONCAT_WS(). Check the documentation for your specific database.
