Sql similar to Excel PROCV

Asked

Viewed 2,628 times

0

In excel there is the PROCV function, where I can get close values by comparing columns.

Ex.:

 A            B
Nome         Dinheiro
Maria        200
João         1000

D                  E          F
Categoria          Min        Max
Médio              0          200
Alto               201        1000

If I use call PROCV(B2,E:F,1,0), it would return me the nearest value between Min,Max in case the result would be "High".

There is something similar in Sql, other than BETWEEN?

1 answer

-2

SELECT MAX(column_name) FROM table_name;

  • Hello, Emerson. No welcome. Further develop your answer. Explain, for example, how your solution works. In this way, your answer will be more useful to the author(a) and to those who find it more.

Browser other questions tagged

You are not signed in. Login or sign up in order to post.