Amazon Interview Question

How would you implement a lookup function in SQL?