Retrieve Daily, Weekly, Monthly Record from SQL Server

Thursday, August 8, 2013

Retrieve Daily, Weekly, Monthly Record from SQL Server

Retrieve Current Weeks Record From Database
SELECT
COUNT(*) AS rows
FROM Orders
WHERE YEARweek(ODate) = YEARweek(CURRENT_DATE);
Retrieve last week Record From Database (starting with Sunday)

Retrieve Daily, Weekly, Monthly Record from SQL Server


  • Cricket Statistics Software

  • Best business opportunity for college students.

  • Sports Management System

  • Hostel management system project modules

  • Student Project Acknowledgement letter

  • Library management system project in JAVA

  • Video CD Library Management System

  • Airline Reservation System

  • Hotel Reservation System

  • PHP Generator for MySQL Software

  • Vehicle Showroom Project Synopsis

  • Electronic Shop Management System

  • ASP.NET Online Advertising

  • School cum College Management System

  • Payroll Management System

  • Vehicle Insurance Management System

  • Supermarket management software

  • Hospital Management System project report

  • College Voting System

  • Sales and Inventory Management System

Posted by Twinkle Tricks at 3:33 AM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ▼  2013 (1)
    • ▼  August (1)
      • Retrieve Daily, Weekly, Monthly Record from SQL Se...

About Me

Twinkle Tricks
View my complete profile
Picture Window theme. Powered by Blogger.