DEV Community

AsadullohRuziev
AsadullohRuziev

Posted on

PostgreSQL unit-11

#postgres #sql #database #mysql

Image description

Image description

SELECT id, make, model, price, ROUND(price * .10) FROM car;
Enter fullscreen mode Exit fullscreen mode

Image description

SELECT id, make, model, price, ROUND(price * .10, 2) FROM car;
Enter fullscreen mode Exit fullscreen mode

Image description

SELECT id, make, model, price, ROUND(price * .10, 2), ROUND(price - ROUND(price * .10),2) FROM car;
Enter fullscreen mode Exit fullscreen mode

Image description

Image description

SELECT id, make, model, price AS original_price, ROUND(price * .10, 2) AS chegirma, ROUND(price - ROUND(price * .10),2) AS aksiyadagi_narx FROM car;
Enter fullscreen mode Exit fullscreen mode

Image description

Top comments (0)

Read next

dm8ry profile image

Installing Vertica on a Single-Node Kubernetes Cluster Using Minikube

Dmitry Romanoff -

tylerlwsmith profile image

Upsert a row in a DB that doesn't use primary keys or unique constraints

Tyler Smith -

jagroop2001 profile image

SQL Cheatsheet: A Handy Reference for SQL Commands with Examples

Jagroop Singh -

mrcaption49 profile image

ACID properties in SQL

Pranav Bakare -