1
SQL Lab 4
1) Retrieve all entries from the employee table with limit set to 10,000.
a. What was the Duration and Fetch times? 0.000 sec / 0.015 sec
b. Set your Limit to Don’t Limit and run your query again.
2
c. How many rows did you retrieve? (leave results setting unlimited for the balnce)
300024
2) All entries from the employee table adding the Where clause to retrieve:
a. All males (# retrieved?) 179973
3
b. All females (# retrieved?) 120051
3) Write a Select -From – Where from the salaries table to retrieve:
a. All entries where the salary is less than or equal to 68000 (# of rows?) 623,981 rows
