摘要:
(1)select * from table where name='D'UNION ALLselect * from table where name<>'D' (2) SELECT CASE WHEN [name]='D' THEN 0 ELSE 1 END FLAG,* FROM TABLE 阅读全文
摘要:
方法一: 使用TOP SELECT TOP 1 * FROM user; SELECT TOP 1 * FROM user order by id desc; 方法二: 使用LIMIT SELECT * FROM user LIMIT 1; SELECT * FROM user ORDER BY i 阅读全文