Hi! Could we please enable some services and cookies to improve your experience and our website?

SQLize | PHPize | SQLtest

Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code

A A A

Login

Choose login method:

Google

GitHub

LinkedIn

StackExchange

Logging in is optional and only required to save your work history. You can continue using the site without logging in.
Donate
A A A
Share
Blog
FAQ

SQL code: Upload Copy Format Clear

Найдите самый длинный фильм в таблице film. Если несколько фильмов имеют одинаковую продолжительность , выберите фильм с наименьшей ценой замены replacement_cost Напишите запрос, который возвращает два столбца: title и release_year rental_duration — продолжительность периода аренды в днях. rental_rate — стоимость проката фильма на период, указанный в столбце rental_duration. length — продолжительность фильма в минутах select title,release_year, length, replacement_cost from film order by length DESC limit replacement_cost ASC

SQL Server:

Stuck with a problem? Got Error? Ask AI support!

SQL Result: ( preserve ) Copy Clear

The site powered by:

PHP versions: PHP 7.4, PHP 8.0, PHP 8.1, PHP 8.2, PHP 8.3, PHP 8.4
RDBMS versions: MySQL 8.0, MySQL 8.0 Sakila (ReadOnly), MySQL 9.3.0, MariaDB 11.4, MariaDB 11.8, MariaDB 11.8 OpenFlights (ReadOnly), MariaDB 10, MariaDB 10 Sakila (ReadOnly), SQLite 3, SQLite 3 Preloaded, PostgreSQL 10 Bookings (ReadOnly), PostgreSQL 14, PostgreSQL 15, PostgreSQL 16, PostgreSQL 17 + PostGIS, PostgreSQL 17 + PostGIS WorkShop (ReadOnly), PostgreSQL 18, MS SQL Server 2017, MS SQL Server 2019, MS SQL Server 2022, MS SQL Server 2022 AdventureWorks (ReadOnly), MS SQL Server 2025, Firebird 4.0, Firebird 4.0 (Employee), Firebird 5.0, RedDatabase 5.0, Oracle Database 19c (HR), Oracle Database 21c, Oracle Database 26ai, SOQOL, ClickHouse

Save Snippet

SQLize | PHPize | SQLtest

Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code

Stuck with a problem? Got Error? Ask AI support!