Posts by Guilherme Nicaretta • 15 points

• 0

  votes

  1

  answer

  73

  views

  Q: Problem with subquery

  Good night, I need to bring the full subquery result: (select (valor * 0.05) from tbl_exames) as 'Valor dos Exames', In a delimiter: delimiter // create procedure comissao(idmedico int) begin select…

  mysql sql

  asked 7 years ago Guilherme Nicaretta 15

• 1

  votes

  1

  answer

  33

  views

  Q: Problem in select

  How to solve this? create table tbl_prescricao( id_prescricao int not null primary key auto_increment, tipo_prescricao varchar(250) not null, valor_prescricao decimal(10,2) ); create table…

  mysql

  asked 7 years ago Guilherme Nicaretta 15