sql select permission with conditions

Question

Is it possible to grant select permission on sql table with some conditions.

For example grant select where table.id = < 50

supplemented: i am talking about ms sql

Answer 1

It's not possible directly.

Though to achieve this task, you can create a View initially with required conditions and then Grant select permission to that particular view.

For more details: mysql GRANT + WHERE