Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How will u get 5 years back record?

Answer Posted / tp

select * from table1 where date between dateadd(yy,-
5,getdate()) and getdate()

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what is raid and what are different types of raid levels?

1087


Do you think BCNF is better than 2NF & 3NF? Why?

1338


Can we write ddl in trigger?

964


what is sql server? : Sql server database administration

1036


Do you know what is difference between stored procedure and user defined function?

1146


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

2251


How to create prepared statements using odbc_prepare()?

1099


What are the types of table?

1026


Can one drop a column from a table?

1064


Can I use sql azure as a backup with log shipping or database mirroring?

156


What is the difference between system objects and user objects?

1208


Explain the types of indexes.

1287


Can you import Microsoft Excel data to SSRS?

135


Does sql server 2016 have ssms?

1002


How can you find out which stored procedures are recompiling?

948