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

giulianaolmos profile image

Technical Interview - Boilerplate 1 - Node + Typescript + PostgreSQL

Giuliana Olmos -

camilacodes profile image

DynamoDB: Query x Scan! Para de torrar dinheiro usando Scan em produção

Camila Figueira -

frederickollinger profile image

Deploy Postgresql with Helm

Frederick Ollinger -

welel profile image

Best Practices for Alembic and SQLAlchemy

Pavel Loginov -