I dont know sql syntax for my table [closed]

by

You could use the DATEADD function to get the desired result:

SELECT  *
  FROM  table
  WHERE paydate >= DATEADD(month, -3, GETDATE())
        AND credit < 10

More Related Contents:

  1. SQL Server: +(unary) operator on non-numeric Strings
  2. Is it possible to write single query on two table which are not connected to each other?
  3. T-SQL split string
  4. Unpivot with column name
  5. How can I get column names from a table in SQL Server?
  6. Conditional WHERE clause in SQL Server
  7. get a comma delimited string from rows [duplicate]
  8. How can I select the first day of a month in SQL?
  9. Is the NOLOCK (Sql Server hint) bad practice?
  10. Multi-statement Table Valued Function vs Inline Table Valued Function
  11. Convert varchar into datetime in SQL Server
  12. Select statement to find duplicates on certain fields
  13. Check if a row exists, otherwise insert
  14. T-SQL datetime rounded to nearest minute and nearest hours with using functions
  15. Parse comma-separated string to make IN List of strings in the Where clause
  16. Compare DATETIME and DATE ignoring time portion
  17. Count Number of Consecutive Occurrence of values in Table
  18. Split function in SQL Server 2008
  19. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  20. Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
  21. TransactSQL to run another TransactSQL script
  22. Store multiple bit values in a single table column
  23. Which SQL query is faster? Filter on Join criteria or Where clause?
  24. SQL Server equivalent to MySQL enum data type?
  25. How to correctly insert newline in nvarchar [duplicate]
  26. How can I group by date time column without taking time into consideration
  27. Using IF ELSE statement based on Count to execute different Insert statements
  28. Cumulative Total in MS Sql server [duplicate]
  29. COALESCE Function in TSQL
  30. Try_Convert for SQL Server 2008 R2

Leave a Comment