Select rows until condition met

by

Use a sub-query to find out at what point you should stop, then return all row from your starting point to the calculated stop point.

SELECT
  *
FROM
  yourTable
WHERE
      id >= 4
  AND id <= (SELECT MIN(id) FROM yourTable WHERE b = 'F' AND id >= 4)

Note, this assumes that the last record is always an ‘F’. You can deal with the last record being a ‘T’ using a COALESCE.

SELECT
  *
FROM
  yourTable
WHERE
      id >= 4
  AND id <= COALESCE(
              (SELECT MIN(id) FROM yourTable WHERE b = 'F' AND id >= 4),
              (SELECT MAX(id) FROM yourTable                          )
            )

More Related Contents:

  1. Update statement with inner join on Oracle
  2. Splitting string into multiple rows in Oracle
  3. GROUP BY with MAX(DATE) [duplicate]
  4. Is there any function in oracle similar to group_concat in mysql? [duplicate]
  5. Can a foreign key be NULL and/or duplicate?
  6. What is the string concatenation operator in Oracle?
  7. Using an Alias in a WHERE clause
  8. How can I introduce multiple conditions in LIKE operator?
  9. Is there any boolean type in Oracle databases?
  10. SQL multiple columns in IN clause
  11. SQL (ORACLE): ORDER BY and LIMIT [duplicate]
  12. Dynamic Oracle Pivot_In_Clause
  13. How can I select from list of values in Oracle
  14. Convert Unixtime to Datetime SQL (Oracle)
  15. Selecting the second row of a table using rownum
  16. How to debug ORA-01775: looping chain of synonyms?
  17. Does Oracle store trailing zeroes for Number data type?
  18. Oracle Update Query using Join
  19. Generating dates between two dates
  20. SQL Command not properly ended?
  21. How to convert Rows to Columns in Oracle? [duplicate]
  22. SQL: getting the max value of one column and the corresponding other columns [duplicate]
  23. SQL not a single-group group function
  24. Oracle: Combine multiple results in a subquery into a single comma-separated value [duplicate]
  25. SQL Keep getting error with ON UPDATE CASCADE
  26. Finding rows that don’t contain numeric data in Oracle
  27. When I call PreparedStatement.cancel() in a JDBC application, does it actually kill it in an Oracle database?
  28. How to retrieve the current value of an oracle sequence without increment it?
  29. Oracle RAC and sequences
  30. SQL Server equivalent of WM_CONCAT function [duplicate]

Leave a Comment