THE HIGHEST VALUES

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
  

Poston Tue, 22 Apr 2008 9:47 am

HELLO GUYS, HOW DO I SELECT a PAYMENT TABLE BRINGING the 100 LARGEST VALUES?

I HAVE TYPE the PAYMENT TABLE where the VALUES I wanted BRING the 100 LARGEST SELECT VALUE THERE how can I do?
carlos12
Location: rio

Poston Tue, 22 Apr 2008 1:31 pm

I would like this:
Code: Select all

SELECT * FROM (
                SELECT * FROM PAGAMENTO
                ORDER BY VALORES DESC
              )
WHERE ROWNUM <=100
hugs!
Toad
Toad
Location: Seattle, WA

Matheus H. Gonçalves
www.toad.com.br
www.twitter.com/toadgeek



Return to SQL

Who is online

Users browsing this forum: No registered users and 3 guests