Question about sqlite max AND min

[timharvey]

Hello, Normally Max and Min will be used like this SELECT MIN([C1]) AS Mini,MAX([C2)) AS Maxi FROM [MyTable]. But with many records, the output results take a long time.

Is there any use for faster retrieval? Thank

[John Z]

Hi timharvey,

I'm no expert but I reached out to a heavy user who said:

"For the Guy if he has a large number of records he must do two queries, one for max and one for min each one must be into a transaction"

Hope this helps.  This site does have SQL users but of course it is mainly about C and some assembly.

John Z