Следите за новинками
в нашем Telegram канале. Жми, чтобы подписаться:)
⊗pyPmDBMVS 115 of 128 menu
◀ ▶

Fetching the minimum value in SQL in Python

To select one minimum value from all records, the function MIN should be applied.

Let's select a user with the minimum id:

query = "SELECT MIN(id) FROM users"

The result of the executed code:

{'MIN(id)': 1}

Select the youngest user from the table.

Among users whose age is greater than 25, select the one with the lowest salary.

← →
↑
English▼
AfrikaansAzərbaycanБългарскиবাংলাБеларускаяČeštinaDanskDeutschΕλληνικάEspañolEestiSuomiFrançaisहिन्दीMagyarՀայերենIndonesiaItaliano日本語ქართულიҚазақ한국어КыргызчаLietuviųLatviešuМакедонскиMelayuမြန်မာNederlandsNorskPolskiPortuguêsRomânăРусскийසිංහලSlovenčinaSlovenščinaShqipСрпскиSrpskiSvenskaKiswahiliТоҷикӣไทยTürkmenTürkçeЎзбекOʻzbekTiếng Việt
We use cookies for website operation, analytics, and personalization. Data processing is carried out in accordance with the Privacy Policy.
accept all customize decline