Top "Sql-order-by" questions

How to add an ORDER BY clause using CodeIgniter's Active Record methods?

I have a very small script to get all records from a database table, the code is below. $query = $this-&…

php codeigniter select activerecord sql-order-by

How to use Oracle ORDER BY and ROWNUM correctly?

I am having a hard time converting stored procedures from SQL Server to Oracle to have our product compatible with …

sql oracle sql-order-by rownum

SQL how to make null values come last when sorting ascending

I have a SQL table with a datetime field. The field in question can be null. I have a query …

sql sorting sql-order-by

MySQL "Group By" and "Order By"

I want to be able to select a bunch of rows from a table of e-mails and group them by …

mysql sql group-by sql-order-by aggregate-functions

Laravel Eloquent: Ordering results of all()

I'm stuck on a simple task. I just need to order results coming from this call $results = Project::all(); Where …

laravel laravel-4 eloquent sql-order-by

PostgreSQL DISTINCT ON with different ORDER BY

I want to run this query: SELECT DISTINCT ON (address_id) purchases.address_id, purchases.* FROM purchases WHERE purchases.product_…

sql postgresql sql-order-by distinct-on

SQL order string as number

I have numbers saved as VARCHAR to a MySQL database. I can not make them INT due to some other …

mysql sql string numbers sql-order-by

SQL Error with Order By in Subquery

I'm working with SQL Server 2005. My query is: SELECT ( SELECT COUNT(1) FROM Seanslar WHERE MONTH(tarihi) = 4 GROUP BY refKlinik_id …

sql-server sql-order-by

SQL Order By Count

If I have a table and data like this: ID | Name | Group 1 Apple A 2 Boy A 3 Cat B 4 Dog C 5 …

mysql database sql-order-by

how to customize `show processlist` in mysql?

I want to order by Time,but seems no way to do that ? mysql> show processlist; +--------+-------------+--------------------+…

mysql filter sql-order-by processlist