SQL Sever 基础语句
-- 查询10条数据
SELECT TOP 10 * FROM student WHERE stu_id = '07200101';
-- 模糊查询
SELECT * FROM student WHERE stu_id like '%2001%';
-- 拼接字符串
SELECT * FROM student WHERE stu_id = '20' + '01';
SELECT * FROM student WHERE stu_id like ('20' + '01' + '%');
更多推荐
SQL server 查询前10条数据
发布评论