2

I want to select all tenth in a field! :( I know this way; "Km" = 10 or "Km" = 20 ... and so, but I am pretty sure theres other way.

I am not SQL literate, but with your help in this site I have managed to do some things, however the most basic are missing in different posts and I would like to find a place with basic (and medium) SQL expressions with practical examples to look for.

Improve this question
0

1 Answer 1

Reset to default
5

Not sure I understood your question, but it looks like it can be achieved with

SELECT * FROM table WHERE chosencolumn % 10 = 0

I'm not sure about the syntax, but if you want to pick all the whole ten's from an integer field this should work.

Improve this answer
0

Not the answer you're looking for? Browse other questions tagged or ask your own question.