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

monikaprajapati_70 profile image

Best Practices for dynamodb

Monika Prajapati -

jao_dev profile image

Docker for beginners: Creating Database Containers

João Vitor -

devartteam profile image

Top Alternative to Navicat for Windows

Devart -

londoso profile image

Vector Database solutions on AWS

Anderson Londoño -