❶ 用sql语句编写如和判断三角形
declare @a int
declare @b int
declare @c int
set @a = 4
set @b = 4
set @c = 7
declare @t table(id int identity(1,1),value int)
insert into @t
select @a
union all select @b
union all select @c
if not exists(select * from @t a
inner join @t b on a.id <>b.id
inner join @t c on a.id <> c.id and b.id <> c.id
where a.value+b.value<= c.value)
begin
if exists(select * from @t a
inner join @t b on a.id <>b.id
inner join @t c on a.id <> c.id and b.id <> c.id
where power(a.value,2)+power(b.value,2) = power(c.value,2) )
print '直角三角形'
else if exists(select * from @t a
inner join @t b on a.id <>b.id
inner join @t c on a.id <> c.id and b.id <> c.id
where power(a.value,2)+power(b.value,2) < power(c.value,2) )
print '钝角三角形'
else
print '锐角三角形'
if not exists(select * from @t a
inner join @t b on a.id <>b.id
inner join @t c on a.id <> c.id and b.id <> c.id
where a.value <> b.value )
print '等边三角形'
if exists(select * from @t a
inner join @t b on a.id <>b.id
inner join @t c on a.id <> c.id and b.id <> c.id
where a.value = b.value)
print '等腰三角形'
end
else
print '不是三角形'
钝角三角形
等腰三角形
❷ PYTHON 等腰三角形 如何做程序
deftriangle(n):
s=''
foriinrange(1,2*n+1):
ifi<=n:
s=s+'X'*i+' '
else:
s=s+'X'*((n-i)+n)+' '
prints
if__name__=="__main__":
n=int(raw_input("pleaseinputtrianglelen:"))
triangle(n)
python 2.6.6测试，结果如题目要求
❸ 编写程序,输出第一行为A,第二行为BBB,第三行为CCCCC,第四行为DDDDDDD,的等腰三角形
#include<stdio.h>
intmain(void)
{
inti,j;
charch='A';
for(i=0;i<4;i++){
for(j=0;j<3-i;j++){
printf("");
}
for(j=0;j<=2*i;j++){
printf("%c",ch);
}
printf(" ");
ch++;
}
return0;
}
❹ java 打印等腰三角形，
java 打印等腰三角形可以采用如下方式：
publicclassMul{
publicstaticvoidmain(Stringargs[]){
for(inti=1;i<=6;i++){
//空格分布
for(intj=6-i;j>0;j--){
System.out.print("");
}
//符号分布
for(intj=1;j<=i;j++){
System.out.print("*");
}
System.out.println();
}
}
}效果如下：
❺ 如何用C语言打印等腰三角形
很标准的等腰三角形#include<stdio.h>
main()
{
int row,col,i;
for(i=1;i<=10;i++){
for(row=1;row<=10-i;row++)
printf(" ");
for(col=1;col<=2*i-1;col++)/* '*'的个数和行数 i 有种内在关系*/
printf("*");
printf("
");
}
❻ sql使用循环输出一个用*显示的等腰三角形
摘要 您好，很高兴为您解答，sql使用循环输出一个用*显示的等腰三角形的解体方案如下：import java.util.Scanner:
❼ 利用pl/sql循环结果输出一幅10行的等腰三角形
declare
V_DATA NUMBER:=&INPUT_NUMBER;
V_STR VARCHAR2(100);
V_LEN NUMBER;
V_NEWSTR VARCHAR2(100);
BEGIN
DBMS_OUTPUT.PUT_LINE('YOU INPUT THE NUMBER:'||V_DATA);
V_STR:=TO_CHAR(V_DATA);
V_LEN:=LENGTH(V_STR);
V_NEWSTR:='';
FOR i in REVERSE 1..V_LEN LOOP
V_NEWSTR:=V_NEWSTR||substr(V_STR,i,1);
END LOOP;
DBMS_OUTPUT.PUT_LINE('THE NEW DATA:'||TO_NUMBER(V_NEWSTR));
END;
❽ PL-SQL疑问
DECLARE
v_i NUMBER :=0;
v_n NUMBER :=10; --- 总行数
v_j NUMBER :=9;
v_k NUMBER :=0;
BEGIN
WHILE v_i < v_n LOOP
WHILE v_j>v_i LOOP -- 这段是打印空格
dbms_output.put(' ');
v_j:=v_j-1;
END LOOP;
WHILE v_k<2*v_i+1 LOOP
dbms_output.put('*');
v_k:=v_k+1;
END LOOP; -- 这段打印每行的* 号
dbms_output.new_line(); -- 打印换行符号
v_i:=v_i+1; --- 所有内部变量复原
v_j:=v_n-1;
v_k:=0;
END LOOP;
END;
--如果是空心菱形：
DECLARE
v_line NUMBER:=0;
v_n NUMBER:=10;
v_i NUMBER:=0;
v_j NUMBER:=0;
BEGIN
WHILE v_line<v_n LOOP
WHILE v_i<v_n-v_line LOOP
dbms_output.put(' ');
v_i:=v_i+1;
END LOOP;
dbms_output.put('*');
WHILE v_j<2*v_line-1 LOOP
dbms_output.put(' ');
v_j:=v_j+1;
END LOOP;
IF v_j*2-1>0 THEN
dbms_output.put('*');
END IF;
v_j:=0;
dbms_output.new_line();
v_line:=v_line+1;
v_i:=0;
END LOOP;
-- 下半部分
v_line :=0;
v_n :=10;
v_i :=0;
v_j :=0;
WHILE v_line<=v_n LOOP
WHILE v_i<v_line LOOP
dbms_output.put(' ');
v_i:=v_i+1;
END LOOP;
dbms_output.put('*');
WHILE v_j<2*(v_n-v_line)-1 LOOP
dbms_output.put(' ');
v_j:=v_j+1;
END LOOP;
IF v_j*2-1>0 THEN
dbms_output.put('*');
END IF;
v_j:=0;
dbms_output.new_line();
v_line:=v_line+1;
v_i:=0;
END LOOP;
END;
-- 你可以自己简化一下
❾ 初学SQL！！怎么用sql语句输出一个*三角形
DECLARE @X INT,@y char ,@z varchar(100)
SET @X=0
set @y='*'
set @z=REPLICATE(@y,@X)
WHILE @X <5
BEGIN
SET @X=@X +1
set @z=REPLICATE(@y,@X)+CHAR(9)
print @z
END
GO
/*
*
**
***
****
******/
你的* 要用乘法 需要使用 REPLICATE()函数
❿ SQL 的几个小作业。。。求解。
1.select Upper(left('what are you doing?',1))+substring(left('what are you doing?',4),2,3)+Upper(substring('what are you doing?',5,2))+substring('what are you doing?',7,2)+Upper(substring('what are you doing?',9,2))
+substring('what are you doing?',11,2)+upper(substring('what are you doing?',13,2))+substring('what are you doing?',15,5)