Member Avatar for arsalanghouri

what query should i write in c# with backend sql server for finding all purchases i did from george in a date range. from purchases table.

  • 2 Contributors
  • 1 Reply
  • 64 Views
  • 23 Hours Discussion Span
  • Latest Post Latest Post by hericles
Member Avatar for hericles

Hi,
SELECT * FROM purchases WHERE client = 'George' and date >= some_date and date < some_other_date;

Obviously change your table columns to suit but that should work for you.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.