我使用了select disctinct语句,其中包含来自sql数据库表的两个字段。这是我的代码。myCommand = New SqlCommand("SELECT DISTINCT Author FROM tblBook UNION SELECT DISTINCT BookCode FROM tblBook
我正在执行以下查询, a.cr_id, When ca.ca_vote = 'Approve' and ca.ca_title='MANAGER2011',101) and dateadd(day,1,convert (varchar(20),'11/16/2011',101)) a.cr_id
尽管适用于cr_id的distinct