Sql Get the last 6

Answer 1

If you're dealing with SQL Server try

Select Top 6 RecordID, NoOfTime, Day&Time from (table) order by Day&Time DESC

Answer 2

SELECT RecordID, NoofTime, Day&Time FROM table ORDER BY Day&Time DESC LIMIT 6;

depending on your SQL engine you will probably have to put some quotes around Day&Time.

The above syntax works with Mysql and PostgreSQL, for varous syntax used for this kins of request you can have a look there select-limit

Answer 3

How about

SELECT TOP(6) *
FROM [Trips]
ORDER BY [Day&Time] DESC

I'm not sure what you mean by "in one line," but this will fetch the 6 most recent records.

Answer 4

For the same line portion, you can use a cursor if you are using SQL server 2008 (might work with 2005 I am not sure).

Answer 5

Oracle

SELECT x.* 
  FROM (SELECT t.* 
          FROM TABLE t 
      ORDER BY day&time DESC) x
 WHERE ROWNUM <= 6

SQL Server

  SELECT TOP 6 t.* 
    FROM TABLE t 
ORDER BY day&time DESC

MySQL/Postgres

  SELECT t.* 
    FROM TABLE t 
ORDER BY day&time DESC
   LIMIT 6