Consult SQL statements or stored procedures

has two columns of data: all is the cumulative total amount of prizes issued, and use is the amount used
id all use
11500
220000
320000
420000
520000
6500
written with sqlserver sql sentence. One record is extracted from these six pieces of data, and the selected records need to be selected in proportion to the number of prizes issued. In other words, each prize appears at random, but it can guarantee how many times the prize will be produced every other time. It is not possible to give out all the prizes with small circulation in the early stage, but all the prizes can appear equally and not centrally.

< hr >

like the table above, there are a total of 1000 prizes, such as 6, which appears about every 20 times, as well as several other awards, probably in this range.

Sql sqlserver

Nov.04,2021

Previous: After resetting your computer, can you still find the plug-ins installed in the browser and the data in the plug-ins?

Next: Mini Game with zero basics for python.

Mysql queries whether there is a value in multiple fields
if the picture is a table, how to find the data equal to 8 in the three fields of mobile1 or mobile2 or mobile3 although you can use where or, ask God how to write sql statements if you don t use where or. Ask for advice ...

Sql sqlserver mysql

Mar.05,2021
The number of input entries on the form page determines how to design the database table
the number of input entries on the form page determines how to design the database table if the new form an and form b or other forms do not unify the fields when submitting data, store them in the database. outline of the design idea what should i...

Javascript php html mysql sqlserver

May.12,2021
In sql server, how do I query whether the field in Table An is included in a field in Table B?
has the following two tables: Table a field: id,tag Table b field: id,title < H2 > query purpose: < H2 > when the tag of table an is contained in the title of table b, it is queried < H2 > the current code looks something like this: < H2 ...

T-sql sqlserver

Jul.22,2021
Sqlserver data real-time Synchronize to mysql solution
oledb provider of linked server 127.0.01 returned an invalid authorization description of the message 7399 -sharp-sharp-sharp problem description the environmental background of the problems and what methods you have tried related codes Ple...

Mysql sqlserver

Aug.27,2021
The company's own computer room, the domain name is a foreign service provider, how to put it on record?
the company is the server placed in its own computer room, and the domain name is purchased on name and godday. Now I want to put it on record. How to operate it? most of the servers given online are too general ....

Sql sqlserver windows-server linux

Jan.17,2022
SQL Server Update statement simplification
the following T-SQL update tablename set =e.,[00:00]=e.[00:00],[01:00]=e.[01:00],[02:00]=e.[02:00],[03:00]=e.[03:00],[04:00]=e.[04:00],[05:00]=e.[05:00],[06:00]=e.[06:00],[07:00]=e.[07:00],[08:00]=e.[08:00],[09:00]=e.[09:00],[10:00]=e.[10:00],[11:00]=e...

Sql sqlserver

Mar.06,2022
How to return the number of records that meet the query criteria before paging in a paging query?
how to check the total number of records returned by answering query conditions in query pagination: select top 10 * from (select row_number() over(order by id asc) as rownumber,* from com_system_menu) temp_row where rownumber>((2-1)*10); the nu...

Postgresql sqlserver mysql sql

Jun.13,2022
Check the weight when inserting a large amount of mssql or mysql data (about 15 million to 20 million)
recently, I am working on a book information management system. There is a table marc that stores the information of books. There are more than 20 fields in it. when importing data, it is required to check the duplicates according to 7 fields, and the...

Mysql sqlserver sql

Jun.21,2022