Select *From [Table]Order by NewID()
Thursday, April 28, 2022
Sql Server: Lấy dòng dữ liệu ngẫu nhiên
(Anhgolden's Blog) - Khi cần lấy dòng dữ liệu ngẫu nhiên, ta dùng câu lệnh sql như sau:
Sql,sql server
2022-04-28T14:55:00+07:00
Loading related posts...
TIN MỚI
CÁC TIN KHÁC
- Error: String or binary data would be truncated - 30-Jul-2021
- Using Alias in Update SQL Statement - 26-Oct-2017
- SQL Server: Phân quyền cho User - 06-Sep-2017
- Functions: Excel vs MS Access vs SQL Server - 17-May-2017
- SQL Server: Tổng hợp - 19-Apr-2016
- Sql: Insert Into Table2 Select * from Table1 - 18-May-2021
- Sql: Select * into New_table from Select - 18-May-2021
- MSSQL: Reduce log file of SQL Server - 05-Aug-2016
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment