| Perform advanced searches in SELECT statement
|
ktsirig
msg:3986076 | 4:23 pm on Sep 8, 2009 (gmt 0) |
Hello all
I wanted to ask if there is a way of inserting some mathematics in an SQL select statement.
What I am interested in is to select all rows from a table where 56<ID<67 for example. Thank you
|
ZydoSEO
msg:3986234 | 8:32 pm on Sep 8, 2009 (gmt 0) |
SELECT *
FROM mytable
WHERE ID > 56 AND ID < 67 You can put mathmatics in lots of parts of a SQL SELECT statement...
|
|
|
