Range query (database)

A range query is a common database operation that retrieves all records where some value is between an upper and lower boundary.[1] For example, list all employees with 3 to 5 years' experience. Range queries are unusual because it is not generally known in advance how many entries a range query will return, or if it will return any at all. Many other queries, such as the top ten most senior employees, or the newest employee, can be done more efficiently because there is an upper bound to the number of results they will return. A query that returns exactly one result is sometimes called a singleton.

Partial match query

Match at least one of the requested keys.

gollark: This can go in my list of "out of context styro quotes".
gollark: I assumed it was just a joke. And it is quite funny. But I guess it's dual-purpose.
gollark: The only message on 19 December is> 6K+ already?!?which seems pretty innocuous, so I'm assuming you're talking about the 20 December one about the (not implemented yet) restricted thing channels and will chalk this down to... time zones, or something.I'd kind of expect you to have said something in the intervening four months if this was a problem for you.
gollark: I mean, you're incoherently rambling about some rights violation and facism, so eh.
gollark: See, you're talking about it as if something happened *recently*, and whatever that is is 4 months ago.

See also

References

  1. "SQL BETWEEN Operator". W3Schools. Retrieved 4 November 2014.


This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.