Which of the following queries selects all data stored in the client table?
select * from client where clientID=2;
select clientID, name, address, contactPerson, contactNumber from client;
select * from client limit 1;
select all from client;
Which of the following queries selects all the programmers from the employee table?
select * from employee where job='Programmer';
select * from employee having job='Programmer';
select * from employee where job='Programmer' group by job having job='Programmer';
select job from employee;
Which of the following queries will not return the total number of employees in the employee table?
select count(employeeID) from employee;
select count(employeeID) as total from employee;
select count(distinct employeeID) from employee;
select count(employeeID) from employee group by employeeID;
Where can we not use aliases?
For columns
For tables
In the WHERE clause
In the SELECT clause
If we want to return the 15th through 20th rows from a query, the correct LIMIT clause is
LIMIT 15, 20
LIMIT 14, 19
LIMIT 14, 5
LIMIT 15, 5
