Monday, March 16, 2009

Queries SQL

 The goal is list all the employees whose name starts with 'S' and ends with 'S'.

select ENAME from EMP where ENAME LIKE ('S%') and ENAME LIKE('%S');

No comments:

Post a Comment

Common JOIN Pitfalls (And How to Avoid Them)

  Common JOIN Pitfalls (And How to Avoid Them) Pitfall 1: Row Explosion (Duplicate Rows) When one side has multiple matches, result rows mul...