how to call select statement in trigger

[alkha]

Hw to call select statement in trigger.query is below


create a row level trigger on emp table.this trigger contains select stmt to ensure that the new salary value falls within the min and man salary for a given job title.

please guide me hw to write code as per the above specification.

[debasisdas]

Show some effort to get any help from our experts.