less than 100 query
Database
2
Posts
2
Posters
0
Views
1
Watching
-
Hi every body. i want to have a query in sql server 2000 which loads the sets of number less than 100. what should i do? SELECT ? [WHERE]? Thanks Rastgar
m.rastgar wrote:
i want to have a query in sql server 2000 which loads the sets of number less than 100. what should i do? SELECT ? [WHERE]?
If you are storing numbers in a column called "MyNumbers" in a table called "MyTable" , then to get all numbers less than 100 you can do:
SELECT MyNumbers FROM MyTable WHERE MyNumbers <100Here is a good place to start leaning SQL[^]