Written by
admin in Thursday, October 25th 2007 under
IT
In this Section we are going to try out all possible simple SELECT queries. First lets create a sample table called emp which should have rows like the following.
emp_no
dept_no
first_name
last_name
salary
7000
114
Read
Vitamin
62,000
4000
113
John
Row
55,000
5000
114
Robert
Howard
65,000
2000
112
Larry
King
60,000
1000
112
Philip
Josheph
65,000
6000
115
Tony
Peter
72,000
3000
111
Micheal
Reed
46,000
8000
113
Philip
Josheph
65,000
9000
115
Tony
Peter
72,000
1100
114
Micheal
Reed
46,000
Follow this command to create a [...]
Popularity: 76% [?]
Click here to read more