Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-10 : 15:29:23
|
| Obi-Ray writes "I am writing a Query for my ASP recordset in order to get the Count Total of a particular Horoscope. The situation is: I have an Access database containing date of birth of many people, and I want to show how many people are in, say, Pisces i.e. between Feb. 19 - Mar. 20. So how can I write this SQL statement so that I can neglect the "year" of their date of birth and also filtering the number of people between Feb. 19 - Mar. 20?Best Regards,Obi-Ray" |
|
|
|
|
|
about SQL query to select horoscope of a date