|
Well here I am learning SQL on Oracle Personal
Server 8 and its actually quite easy to pick up! It's just really tedious
but I can see the merits in it and I'll be sure to nab a copy of it from
somewhere (Its free from their website but like hell I'm going to download
it on dialup!). Here's my homework:
=> Will this statement execute successfully?
SQL> SELECT
ename, job, sal Salary
2 FROM
emp; => Answer: No (need to shove AS
"Salary" after sal on line 1)
Done Did
=> /em skips on to more interesting questions.
=> Display the name, job, and salary for all employees
whose job is Clerk or Analyst and their salary is not equal to $1000,
$3000, or $5000.
SQL> SELECT
ename, job, sal
FROM
emp
WHERE sal<>
ANY (1000,3000,5000)
AND
job='CLERK'
OR
job='ANALYST';
Done Did (and it
works too)
I'll do more for this tomorrow (today, because its
1:34am). |