• 0
Sign in to follow this  
Halfar

Selecionar O Menor Numero

Question

Na base de dados tenho registros cujo conteudo são numeros aleatorios, por exemplo:

Registro 1 = 101

Registro 2 = 300

Registro 3 = 7

Preciso de uma instrucao sql que selecione o registro que contenha o menor numero, no exemplo acima deve ser selecionado o registro 3.

Share this post


Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0

cara você pode usar assim

sql = "select * from tabela order by registro"

falow

Share this post


Link to post
Share on other sites
  • 0

select MIN( registro ) from tabela

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this