Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
PostreSQL: Subquery
Language:
Ada
Assembly
Bash
C#
C++ (gcc)
C++ (clang)
C++ (vc++)
C (gcc)
C (clang)
C (vc)
Client Side
Clojure
Common Lisp
D
Elixir
Erlang
F#
Fortran
Go
Haskell
Java
Javascript
Kotlin
Lua
MySql
Node.js
Ocaml
Octave
Objective-C
Oracle
Pascal
Perl
Php
PostgreSQL
Prolog
Python
Python 3
R
Rust
Ruby
Scala
Scheme
Sql Server
Swift
Tcl
Visual Basic
Layout:
Vertical
Horizontal
--PostgreSQL 9.6 --'\\' is a delimiter --create a table CREATE TABLE product( product_id INT PRIMARY KEY NOT NULL, sku CHAR(50) NOT NULL, category VARCHAR(50) NOT NULL, date TIMESTAMP, price DECIMAL (10,2) ); INSERT INTO product (product_id, sku, category,date, price)VALUES (101, 'A113M1', 'Mascara', '2020-04-23', 23),(102, 'A212M2 ', 'Mascara', '2020-02-12', 23),(103, 'A221NP2', 'Nail Polish', '2020-03-07', 15), (104, 'A332NP2', 'Nail Polish', '2020-05-21', 15),(105 , 'A36LIPG', 'Lipgloss', '2020-07-15', 19); --run subquery SELECT product_id,sku,date FROM product WHERE price = (SELECT max(price) FROM product WHERE category='Mascara');
absolute service time: 0,46 sec
fork mode
|
history
|
discussion
product_id
sku
date
1
101
A113M1
23.04.2020 00:00:00
2
102
A212M2
12.02.2020 00:00:00