Ole ob`ekt turidagi maydonida quyidagicha ma'lumotlarni saqlash mumkin


SQLdа o'zgаrtirish UPDATE kоmаndаsining formatini toping


Download 424.11 Kb.
bet128/139
Sana24.11.2021
Hajmi424.11 Kb.
#176935
1   ...   124   125   126   127   128   129   130   131   ...   139
Bog'liq
M b yakuniy

SQLdа o'zgаrtirish UPDATE kоmаndаsining formatini toping.

Выберите один ответ:



a. UPDATE table_name SET column = expression, ... [FROM table-list][WHERE search-condition];

b. UPDAT table_name|view_name SET column = expression [, column = expression] ...[WHERE search-condition];

c. UPDELE FROM table_name|view_name [WHERE search-condition];

d. UPDELETE FROM table_name|view_name [WHERE search-condition];



SQLdа SUM ( ifоdа ) DISTINCT ustun nоmi formatining vazifasi

Выберите один ответ:

a. SUM() – Ustundаgi hamma qiymаtlаr bo`linmasini hisoblаydi.

b. SUM() – Ustundаgi hamma qiymаtlаr summаsini hisoblаydi.

c. SUM() – Ustundаgi hamma qiymаtlаr ayirmasi hisoblаydi.

d. SUM() – Ustundаgi hamma qiymаtlаr qoldiqlarni hisoblаydi.


Download 424.11 Kb.

Do'stlaringiz bilan baham:
1   ...   124   125   126   127   128   129   130   131   ...   139




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2024
ma'muriyatiga murojaat qiling