qq_39649444的博客

原创 SQL

1.top Select top 30 percent from table1 2.in Select * from table1 where lastname in (“d”,“b”) 3.like Select * from table1 where lastname like ‘刘%’ %代表一个或者多个字符，_代表一个字符，[]代表单一字符，[^字符]或[!字符]代表不包含该字...