Kamus Pengaturcaraan

Manual teknikal dalam talian untuk pengaturcara perkhidmatan

Carian popular:

PHP MySQL jquery HTML CSS

Semua kamus

avg

count

max

min

avg

sum

random

abs

upper

lower

length

version

insert

select

where

andor

update

delete

glob

limit

orderby

groupby

having

distinct

unions

unionall

null

indexedby

after

truncatetable

autoincrement

explain

vacuum

tutup

SQLite Kamus berkaitan

count

max

min

avg

sum

random

abs

upper

lower

length

version

insert

select

where

andor

update

delete

glob

limit

orderby

groupby

having

distinct

unions

unionall

null

indexedby

after

truncatetable

autoincrement

explain

vacuum

laman utama kamus

pangkalan data

SQLite

Fungsi AVG SQLite

Fungsi AVG SQLite Arahan terperinci untuk digunakan

Fungsi AVG SQLite

terjemahan bahasa Cina kemas kini terkini: 2018-05-16 14:21:30

avg

UK ['eɪvɡ] AS ['eɪvɡ]

abbr.purata purata

Fungsi AVG SQLite sintaks

Fungsi: Fungsi agregat SQLite AVG mengira purata lajur tertentu.

Sintaks: sqlite> PILIH purata (lajur data tertentu) DARI TABLENAME;

Fungsi AVG SQLite contoh

COMPANY 表

ID          NAME        AGE         ADDRESS     SALARY
----------  ----------  ----------  ----------  ----------
1           Paul        32          California  20000.0
2           Allen       25          Texas       15000.0
3           Teddy       23          Norway      20000.0
4           Mark        25          Rich-Mond   65000.0
5           David       27          Texas       85000.0
6           Kim         22          South-Hall  45000.0
7           James       24          Houston     10000.0

实例：
sqlite> SELECT avg(salary) FROM COMPANY;
结果：
avg(salary)
----------------
37142.8571428572

Fungsi AVG SQLite

serahkan