# Simple SQL question

**URL:** <https://forum.kirupa.com/t/simple-sql-question/279155>\
**Category:** Uncategorized\
**Created:** [January 10, 2009, 8:41am UTC](https://forum.kirupa.com/t/simple-sql-question/279155 "2009-01-10T08:41:41Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![bootiteq](https://avatars.discourse-cdn.com/v4/letter/b/eb9ed0/32.png) [@bootiteq](https://forum.kirupa.com/u/bootiteq)\
**Post date:** [January 10, 2009, 8:41am UTC](https://forum.kirupa.com/t/simple-sql-question/279155/1 "2009-01-10T08:41:41Z")

</div>

How do you, and is it possible to order by 2 different rows?

Ordering with a greater preference to **ord** than **date\_created**?

eg…

SELECT \* FROM items ORDER BY **ord** , **date\_created**