Suppose you have 1000 data, I adopt the way of three-stage filtration, the first level according to the data table below the top 70% of the first value preserving 700 data, the second level according to the data table below the second value preserving the top 70% of 490 data, the third level according to the data on the surface of the table before the third value preserving 50 data,

Could you tell me how to write the SQL statement?

CodePudding user response:

Why don't you directly in the SQL statement where conditions set directly to filter out all check out of the results is not you want

CodePudding user response:

Result1=SELECT TOP 50 * FROM table ORDER BY ABS (value1-10);

Result1=SELECT TOP 10 * FROM result1 ORDER BY ABS (value2-20);

To achieve this effect, how to set up the where condition?

CodePudding user response:

Search nested SQL queries