[with] the group id of the random records in the table 1, records, records of set output?-CodePudding

Home > database > [with] the group id of the random records in the table 1, records, records of set output?

[with] the group id of the random records in the table 1, records, records of set output?

Time：12-05

if you have any ID for 1-20 data; The field group_id for 1-4; Each group_id randomly take 1 the data; Output of record sets,

ID group_id value
1 1 sw1
2 22 1 d
3 1 a12
4 1 d3s
5 1 af2
6 2 se3
7 2 xs1
8 2 LRT
9 2 fb6
10 2 7 rj
11 3 sr4
12 three chi
13 3 LTF
3 of 14 cyh
15 3 goe
16 4 STH
17 4 atg
18 4 guj
19 4 muhmuh
Twenty four koi

Page link：https//www.codepudding.com/database/92331.html

Prev:MySQL export text garbled question type attribute

Next:About relations division of the small problems in set operation, trouble the great spirit guide, tha

Tags：

MySQL

The 2020-12-02: mysql, there is ID on the primary key table,
MSSQL output 1000 records less than a second, but into a JOb
Needs to be displayed on the page 2 different sets of record
Kettle can execute hive statement normally, but the correct
C # a paging controls how to obtain the total number of reco
SQL server 2008 login how to query the history records, such
For help! Awk to statistics the number of requests every 5 m
Use vnpy back across the measurement cycle strategy, how to
Ask a simple EF multiple records query problem
How to put a table according to the condition of the records

Links：
CodePudding