Select the second last record in SQL

Asked Jul 13 '15 at 10:39

Active Jul 13 '15 at 10:51

Viewed 334 times

I need get the second last record of DATE with Google Column but is impossible because the query very complex.

I tried "-1" on any piece of query and nothing

SELECT d.dominio AS dominio_dominio,
    p.palavra AS palavras_palavra,
    rm.posicao_google AS google,
    rm.verificado AS verificao_robo,
    rm.usuario AS rank_dono,
p.id AS id_palavra
FROM rank_monitor rm
JOIN dominio d ON d.id = rm.dominio
JOIN palavras p ON p.id = rm.palavras
LEFT JOIN rank_monitor rm1 ON rm1.dominio = rm.dominio
    AND rm1.palavras = rm.palavras
    AND rm1.verificado > rm.verificado
WHERE rm1.id IS NULL
    AND rm.usuario = '35'
GROUP BY rm.palavras-1
ORDER BY rm.posicao_google ASC

How can I give the second last result Google column?

I saw the question Select the SECOND LAST record in each group but not solve.

edited May 23 '17 at 12:21

Community

asked Jul 13 '15 at 10:39

Bruno Pinna

1

You want last column then use reverse order with limit i.e. ORDER DESC with LIMIT 1,1 – Ananth Jul 13 '15 at 10:44
Provide sample data and expected results. – Stanislovas Kalašnikovas Jul 13 '15 at 10:49
[link](http://postimg.org/image/ozyztw0f7/) – Bruno Pinna Jul 13 '15 at 11:21
i have the image, how i post the sql ? sqlfindlle are down. thanks :) – Bruno Pinna Jul 13 '15 at 11:26
i store the sql on [SQL STRUCTURE](https://jsfiddle.net/4cfe5w48/) – Bruno Pinna Jul 13 '15 at 11:29
@BrunoPinna Please use **http://sqlfiddle.com/** – Radu Gheorghiu Jul 13 '15 at 12:25

Select the second last record in SQL

0 Answers0