Python + Sqlite 3 query with multiple conditions

Question

I want to query a table paths with 5 columns (user, trial , t, x, y) to get user, trial and t where first condition: x*x+y*y<100 and second condition: t has the max value.

I solved only the half of the problem, implemented the first condition:

query = '''
    SELECT user, trial , t, 
    FROM paths
    WHERE x*x+y*y<100
    '''

Got this: enter image description here

I must add the second condition such as only the user + trial with max value for t should be selected. Example: row 1226 5 2.348045

Please help me to find a solution. Thank you!

I'm not quite sure what "t has the max value" means. Could you explain? Is t greater than x and y, greater than user or trial? — Captain Jack Sparrow
– Captain Jack Sparrow, Commented Mar 30, 2020 at 21:59
The sqlite website has a lot of documentation, much of which seems to be geared to those who already know SQL. So I would suggest you take a look at www.sqlitetutorial.net. That site gives lots of examples of the different features of the SQL dialect as understood by sqlite. — Roland Smith
– Roland Smith, Commented Mar 30, 2020 at 23:18

tonypdmtr · Accepted Answer · 2020-03-30 23:14:27Z

1

For SQLite3 specifically (it won't work with any SQL), you can simply change t to max(t) t in your SELECT statement. (Also, remove the dangling comma after t,).

If you need max for each user, add GROUP BY user at the end.

answered Mar 30, 2020 at 23:14

tonypdmtr

3,2752 gold badges20 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python + Sqlite 3 query with multiple conditions

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related