[Oracle SQL] select 연습문제

1.

describe student;

2.

describe subject;

3.

select * from student;

4.

select * from enrol;

 

5. 

select stu_no, stu_name
from student;

6.

 

23.

select sub_name, sub_prof
from subject
where sub_prof like '이%';

24.

select stu_dept || '과 ' ||stu_name||'입니다.' as 자기소개
from student;

25. 

select *
from student
where stu_dept = '컴퓨터정보';

 

55.

select stu_no, stu_name, stu_dept
from student
where stu_gender ='M' or stu_grade = 1 ;

56.

select stu_no, stu_name
from student
order by stu_no ;

57.

select stu_name, stu_no
from student
order by stu_name ; 

58.

select stu_dept, stu_name, stu_no
from student 
order by stu_dept, stu_name ; 

59.

select * 
from student 
order by stu_dept, stu_grade desc ; 

60.

select *
from student 
order by stu_dept, stu_class ;