SQL Server queries all users who have purchased products in a certain period of time, and SQL server has bought

SQL Server queries all users who have purchased products in a certain period of time, and SQL server has bought

The goods table is as follows:

Name time productA 13:23:00 WFEYB 15:23:00; 34 ASGA 13:47:20 SGHC 19:56:03 HRTC 14:00:00 XCCA ESFW

Select distinct oo. name FROM (SELECT name, DATE_FORMAT (time, '% h: % m') AS ti FROM goods) as oo where ti BETWEEN '12: 00' AND '14: 00 ';

The above section describes how to use SQLServer to query all users who have purchased products in a certain period of time. I hope it will be helpful to you. If you have any questions, please leave a message for me, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!