LibreOffice Help - master/text/sdatabase — Turkish @ TDF Weblate - LibreOffice: SELECT SUM("Price") FROM "Article".

Translation

Context 02010100.xhp par_id3154591 help.text

English

VrHLf

Turkish

Needs editing

Skip

Context	English	Turkish
02010100.xhp par_id3149979 help.text	Count	Say
02010100.xhp par_id3155810 help.text	Determines the number of records in the table. Empty fields can either be counted (a) or excluded (b).
02010100.xhp par_id3151333 help.text	a) COUNT(*): Passing an asterisk as the argument counts all records in the table.	a) COUNT(*): Değişken olarak yıldız işareti geçirmek tablo içindeki tüm kayıtları sayar.
02010100.xhp par_id3152889 help.text	b) COUNT(column): Passing a field name as an argument counts only the records in which the specified field contains a value. Records in which the field has a Null value (i.e. contains no textual or numeric value) will not be counted.
02010100.xhp par_id3153067 help.text	Maximum	Azami
02010100.xhp par_id3159221 help.text	Determines the highest value of a record for that field.	Bu alan için bir kaydın en yüksek değerini belirler.
02010100.xhp par_id3146866 help.text	Minimum	Asgari
02010100.xhp par_id3157982 help.text	Determines the lowest value of a record for that field.	Bu alan için bir kaydın en düşük değerini belirler.
02010100.xhp par_id3154828 help.text	Sum	Toplam
02010100.xhp par_id3154536 help.text	Calculates the sum of the values of records for the associated fields.	İlişkili alanlar için kayıtların değerlerinin toplamını hesaplar.
02010100.xhp par_id3148820 help.text	Group	Grupla
02010100.xhp par_id3149438 help.text	Groups query data according to the selected field name. Functions are executed according to the specified groups. In SQL, this option corresponds to the GROUP BY clause. If a criterion is added, this entry appears in the SQL HAVING sub-clause.
02010100.xhp par_id3156038 help.text	You can also enter function calls directly into the SQL statement. The syntax is:
02010100.xhp par_id3156340 help.text	SELECT FUNCTION(column) FROM table.	SELECT İŞLEV(sütun) FROM tablo.
02010100.xhp par_id3155075 help.text	For example, the function call in SQL for calculating a sum is:	Örneğin, SQL'de bir toplamı hesaplamak için işlev çağrısı şöyledir:
02010100.xhp par_id3154591 help.text	SELECT SUM("Price") FROM "Article".	SELECT SUM("Price") FROM "Article".
02010100.xhp par_id3159205 help.text	Except for the <emph>Group</emph> function, the above functions are called Aggregate functions. These are functions that calculate data to create summaries from the results. Additional functions that are not listed in the list box might be also possible. These depend on the specific database engine in use and on the current functionality provided by the Base driver used to connect to that database engine.
02010100.xhp par_id3148651 help.text	To use other functions not listed in the list box, you must enter them manually under <emph>Field</emph>.	Liste kutusunda listelenmeyen işlevleri kullanmak için, işlevleri <emph>Alan</emph> altına elle girmelisiniz
02010100.xhp par_id3155098 help.text	You can also assign aliases to function calls. If you do not want to display the query string in the column header, enter a desired substitute name under <emph>Alias</emph>.
02010100.xhp par_id3155539 help.text	The corresponding function in an SQL statement is:	SQL deyimindeki karşılık gelen işlev şudur:
02010100.xhp par_id3149425 help.text	SELECT FUNCTION() AS alias FROM table	SELECT İŞLEV() AS alias FROM tablo
02010100.xhp par_id3144431 help.text	Example:	Örnek:
02010100.xhp par_id3154614 help.text	SELECT COUNT(*) AS count FROM "Item"
02010100.xhp par_id3154610 help.text	If you run such a function, you cannot insert any additional columns for the query other than as an argument in a "Group" function.
02010100.xhp par_id3154644 help.text	<emph>Examples</emph>	<emph>Örnekler</emph>
02010100.xhp par_id3151120 help.text	In the following example, a query is run through two tables: an "Item" table with the "Item_No" field and a "Suppliers" table with the "Supplier_Name" field. In addition, both tables have a common field name "Supplier_No."
02010100.xhp par_id3155144 help.text	The following steps are required to create a query containing all suppliers who deliver more than three items.
02010100.xhp par_id3153240 help.text	Insert the "Item" and "Suppliers" tables into the query design.
02010100.xhp par_id3148807 help.text	Link the "Supplier_No" fields of the two tables if there is not already a relation of this type.
02010100.xhp par_id3161652 help.text	Double-click on the "Item_No" field from the "Item" table. Display the <emph>Function</emph> line using the context menu and select the Count function.
02010100.xhp par_id3151009 help.text	Enter >3 as a criterion and disable the Visible field.

Loading…

ayhanyalcinsoy Translation changed LibreOffice Help - master text/sdatabase Turkish	English SELECT SUM("Price") FROM "Article". Turkish 33 characters edited Current translation Translated ~~"Makaleden" TOPLAM ("Ücreti") seçin~~SELECT SUM("Price") FROM "Article". 5 months ago
ayhanyalcinsoy Suggestion accepted LibreOffice Help - master text/sdatabase Turkish	English SELECT SUM("Price") FROM "Article". Turkish 36 characters edited Translated "Makaleden" TOPLAM ("Ücreti") seçin. 5 months ago
inci Suggestion added LibreOffice Help - master text/sdatabase Turkish	English SELECT SUM("Price") FROM "Article". Turkish 36 characters edited "Makaleden" TOPLAM ("Ücreti") seçin. 5 months ago
ayhanyalcinsoy Suggestion removed LibreOffice Help - master text/sdatabase Turkish	English SELECT SUM("Price") FROM "Article". Turkish 28 characters edited TOPLAMI SEÇ("Ücret") YAZIDAN 5 months ago
anonymous Suggestion added LibreOffice Help - master text/sdatabase Turkish	English SELECT SUM("Price") FROM "Article". Turkish 28 characters edited TOPLAMI SEÇ("Ücret") YAZIDAN 5 months ago