最小公倍数

WBOYOriginal: 2016-06-07 14:55:191526browse

求两个整数的最小公倍数无 DECLARE @num1 BIGINT, @num2 BIGINT SET @num1=6 SET @num2=8DECLARE @result BIGINT DECLARE @max INT DECLARE @times INT IF @num1 = @num2 SET @max=@num2 ELSE SET @max=@num1 SET @times=@max WHILE( @times = @max ) BEGIN

求两个整数的最小公倍数

DECLARE @num1 BIGINT, 
        @num2 BIGINT 

SET @num1=6 
SET @num2=8

DECLARE @result BIGINT 
DECLARE @max INT 
DECLARE @times INT 

IF @num1 <= @num2 
  SET @max=@num2 
ELSE 
  SET @max=@num1 

SET @times=@max 

WHILE( @times >= @max ) 
  BEGIN 
      IF( @times%@num1 = 0 
          AND @times%@num2 = 0 ) 
        BEGIN 
            SET @result=@times 

            BREAK 
        END 

      SET @times=@times + 1 
  END 

SELECT @result

Statement：

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Previous article：oracle decode 函数实现行转列Next article：ORACLE毫秒与日期的相互转换

See more

最小公倍数

Related articles