Sql

Search

sql last 7 days

 SELECT id, NewsHeadline as news_headline, NewsText as news_text, state CreatedDate as created_on
 FROM News 
 WHERE CreatedDate >= DATEADD(day,-7, GETDATE())

Comment

PREVIOUS	NEXT

Code Example
Sql :: oracle user last connection date
Sql :: linux command line import mysql database
Sql :: create schema sql server
Sql :: microsoft sql server extract hour and minute from datetime
Sql :: how to rename table in sql
Sql :: select password from user mysql
Sql :: insert column with default value in sql
Sql :: postgres change column type string to integer
Sql :: how to copy a table from one database to another in mysql
Sql :: sql count duplicate rows
Sql :: oracle check table space
Sql :: how to get non distinct values in sql
Sql :: postgres extract number from string
Sql :: mysql count lines
Sql :: timestamp in sqlite
Sql :: django sqlite database
Sql :: oracle sql query to make column data uppercase
Sql :: generate random data postgresql
Sql :: import local sql into remote mysql
Sql :: check sql database table lock
Sql :: Mysql Workbench takes very long time to execute the first query
Sql :: wordpress change user password sql
Sql :: postgresql update to unique
Sql :: delete all rows from table mysql
Sql :: mysql breakline on string
Sql :: select insert new table sql server
Sql :: alter table drop column
Sql :: get current date data in mysql
Sql :: oracle update with sequence
Sql :: sql fillna

Search

SQL

sql last 7 days

ADD CONTENT