May I use a cursor to retrieve the data height or use a subquery or a join such as join?

wiwiclcl

thanks

unkmass

You can try it and know the result.

wtyrambo

Try not to use cursors, because cursors perform poorly!

prajna

Specific analysis

hurricane6

Of course, it depends on the situation, but in general, if your sql statement can be implemented in these three ways
Join-Subqueries (Related Subqueries)-Cursors

恶魔右指

It can't be compared, it depends on the specific situation

dream88

Don't use cursors if you can use subqueries