클립보드: 두 판 사이의 차이

@@ 4번째 줄: / 4번째 줄: @@
-U SUCK
+select name||'''s ID : '||id||', WEIGHT is '|| weight||'Kg' "ID AND WEIGHT" from student;
+select name||'('||hobby||')'||', '||name||''''||hobby||'''' from "NAME AND JOB"emp2;
+select name||'''s PAY is $'||pay from "Name and Pay" emp2;
-select name||'''s ID : '||id||', WEIGHT is '|| weight||'Kg' "ID AND WEIGHT" from student;
-select name||'('||hobby||')'||', '||name||''''||hobby||'''' from "NAME AND JOB"emp2;
-select name||'''s PAY is $'||pay from "Name and Pay" emp2;
+select name,empno from emp2 where name='Tom Cruise';
+select name,empno from emp2 where empno='19900101';