SQL consult!!!!!!!!!!!!!!!-CodePudding

CodePudding

Home > database > SQL consult!!!!!!!!!!!!!!!

SQL consult!!!!!!!!!!!!!!!

Time：09-20

query larger fruit

CodePudding user response:

So how much is big

CodePudding user response:

1/f, reference Po pinch reply:

so much calculate large

number of table 2

CodePudding user response:

Select * from (
The select t1. Fruit, row_number () over (partition by t1. The fruit order by t1. Size desc) rn from tab1 t1, t1)
Tab2 t2
Where a t1. Rn & lt;=t2. Count
And t1. Fruit=t2. Fruit;

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

Prev:Oracle will query results into a json data format

Next:Ask: the actual number of rows returned beyond the request of the number of rows

Tags：

Non-technical area

Links：
CodePudding