Top "Between" questions

Optimize Oracle Between Date Statement

I got an oracle SQL query that selects entries of the current day like so: SELECT [fields] FROM MY_TABLE …

sql oracle indexing between

JPA 2.1 CriteriaQuery between Date

How can I use CriteriaQuery with BETWEEN clause in Date? I have tried this without success; the DAO method: public …

jpa between criteriaquery

SQL query multiple ranges without using multiple OR clauses (nesting LIKE, BETWEEN)

I commonly have to query an extremely large table for multiple variables with many conditions per variable. Often times, a …

sql performance between

MySQL Select : where time is greater then and less than time

I have a function that accepts two time parameters: $start_time, $end_time each parameter is define as time in …

mysql between

Is the 'BETWEEN' function very expensive in SQL Server?

I'm trying to join two relatively simple tables together, but my query is experiencing serious hangups. I'm not sure why, …

sql-server performance between

BETWEEN operator vs. >= AND <=: Is there a performance difference?

These two statements are logically equivalent: SELECT * FROM table WHERE someColumn BETWEEN 1 AND 100 SELECT * FROM table WHERE someColumn >= 1 AND …

sql-server performance between

Line of dots between items

Restaurant web site and menu. I need to get "line of dots" between menu item and price. I need to …

css line between dotted-line

searching data between dates stored in varchar in mysql

I am storing my dates in column server_date_time in varchar in dd/mm/yyyy format and i want …

mysql date compare between

MySQL summing value across date range

I have a table with each row containing a date and some arbitrary, numeric value. I need to sum this …

mysql date between

Count the number of records active between two dates

I am trying to do a query to retreive the number of active calls for a given time, I have …

sql sql-server date intervals between