SQL's posterous

« Back to posts
  • Viewed
    times
February 23, 2010

Inline queries - do more with the FROM clause

  • Edit
  • Delete
  • Tags
  • Autopost
Table names aren't the only thing that can come after FROM. You can use entire queries, as described on JustinSomnia.org's great SQL tips and tricks page.

His example: "

select *from (select sal as salary, comm as commission from emp) xwhere salary < 5000;
"
Tweet
  • 0 responses
  • Like
  • Comment