lezão 0 Report post Posted November 19, 2016 Bom dia galera! estou precisando de uma ajudinha, tenho uma tabela q tem nomes de times e pontos. Quero retornar o terceiro maior valor como fazer isso ? Share this post Link to post Share on other sites
lezão 0 Report post Posted November 19, 2016 tentei assim: sql = "SELECT TOP 3 * FROM Clube ORDER BY P DESC" Mas ele me retorna os Três primeiros com o maior valor; Preciso q me retorne apenas o terceiro!!!! Share this post Link to post Share on other sites
Motta 645 Report post Posted November 19, 2016 Select top 1* from (select top 3 * from clube order by p desc) Deve resolver Share this post Link to post Share on other sites
lezão 0 Report post Posted November 19, 2016 Ola Motta, boa tarde! naun deu certo naun. olha o erro q deu!!! Microsoft JET Database Engine error '80040e14' The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect. /19.asp, line 30 Share this post Link to post Share on other sites
Motta 645 Report post Posted November 19, 2016 Talvez algum erro bobo de sintaxe Share this post Link to post Share on other sites
lezão 0 Report post Posted November 20, 2016 ja revisei td e da o mesmo erro ! Share this post Link to post Share on other sites
Motta 645 Report post Posted November 20, 2016 Usando RANK das Analytic Function talvez http://stackoverflow.com/questions/8235933/sql-query-to-find-top-n-values-for-a-column-for-a-specific-type-of-data-set Share this post Link to post Share on other sites
Fernando C 128 Report post Posted November 21, 2016 se entendi bem, a dúvida é de SQL. tente isso: SELECT * FROM (SELECT TOP 3 * FROM times ORDER BY pontos DESC) WHERE id not in(SELECT TOP 2 id FROM times ORDER BY pontos DESC); Share this post Link to post Share on other sites
Motta 645 Report post Posted November 21, 2016 Não conheço síntaxe de Sql Server mas no que o sql do post #2 estaria errado ? Share this post Link to post Share on other sites
lezão 0 Report post Posted November 21, 2016 Post #8 Resolvido.... Valeu Fernando C Share this post Link to post Share on other sites
Fernando C 128 Report post Posted November 21, 2016 Não conheço síntaxe de Sql Server mas no que o sql do post #2 estaria errado na verdade, o erro é no post #3: Select top 1* from... faltou um espaço entre 1 e * Share this post Link to post Share on other sites