Ask Your Question
1

LibreOffice BASE - I need help for functions in query design view [closed]

asked 2014-11-16 05:41:16 +0200

mrmister gravatar image

updated 2014-11-16 05:42:30 +0200

Hello, I would need help, exactly, clear documentation with examples, about how may I use functions in the query design view in LibreOffice BASE (not interested about how to use functions in SQL at the moment).

The functions you can see in the menu (at the grid) in the query design view are:

Average

Count

Maximum

Minimum

Sum

Every

Any

Some

STDDEV_POP

STDDEV_SAMP

VAR_SAMP

VAR_POP

Collect

Fusion

Intersection

Group

I need some PDF or clear documentation, explaining how to use every function with a documented example. Any idea where I can get that information?

Cheers

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-03-06 22:44:32.990898

Comments

Just to give you a simple example, say you have a table of Cities and States and you want to know how many Cities are in each state. You can say SELECT State, Count(Cities) GROUP BY State. The result will be one record for each state, no matter how many records for that state, with the state name, and the count of cities in that state.

EasyTrieve gravatar imageEasyTrieve ( 2016-12-13 08:13:10 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2014-12-09 02:18:30 +0200

mrmister gravatar image

No one is willing to help ? :(

edit flag offensive delete link more

Comments

Jesus f Christ, with all that rep you should know this way of yours is wrong ! Don't make answers that aren't answers !

rautamiekka gravatar imagerautamiekka ( 2014-12-09 09:40:15 +0200 )edit
1

Jesus and Christ are words I understand, what I don't understand is the F. Explain me please, what mean the F. I am asking for documentation showing me examples about functions, how to use functions. I need help with this.

mrmister gravatar imagemrmister ( 2014-12-09 23:45:02 +0200 )edit

Delete this answer of yours.

rautamiekka gravatar imagerautamiekka ( 2014-12-10 00:02:46 +0200 )edit

Question Tools

2 followers

Stats

Asked: 2014-11-16 05:41:16 +0200

Seen: 852 times

Last updated: Dec 09 '14