by introducing a row_number function that partitions by the two columns, you cna find unique rows; fromt here, it's just the same query you had before, but hitting a subquery isntead of the raw table:
SELECT
TOP 6
WORKID,
AUTHORID
FROM (SELECT
ROW_NUMBER() OVER(PARTITION BY WORKID, AUTHORID ORDER BY WORKID, AUTHORID) AS RW,
WORKID,
AUTHORID
FROM dbo.LITERARYWORKS) MyAlias
WHERE RW = 1--finds Uniqueness across WORKID, AUTHORID
ORDER BY
CHECKSUM(NEWID())
Lowell