you have a table engineers with the following structure enggid int 4..., MS SQL Server 2005, Databases

MS SQL Server 2005

Test
- Model Test
Index

Question:You have a table "engineers" with the following table structure:
enggid                int(4)
deptname            varchar(50)
salary                int(4)
You want to display the minimum and maximum salaries of the individual departments. Which of the following queries will fetch the desired results?

A select deptname, min(salary) as Minimum, max(salary) as Maximum from engineers 
B select deptname, min(salary) as Minimum, max(salary) as Maximum from engineers group by deptname 
C select deptname, min(salary) as Minimum, max(salary) as Maximum from engineers group by salary 
D select deptname, min(salary) as Minimum, max(salary) as Maximum from engineers order by deptname 
E None of these

/76

+ AnswerB

+ Report

Descriptive on MS SQL Server 2005 Ebook

Total Preview: 577

Question:You have a table "engineers" with the following table structure: enggid int(4) deptname varchar(50) salary int(4) You want to display the minimum and maximum salaries of the individual departments. Which of the following queries will fetch the desired results?

A select deptname, min(salary) as Minimum, max(salary) as Maximum from engineers

B select deptname, min(salary) as Minimum, max(salary) as Maximum from engineers group by deptname

C select deptname, min(salary) as Minimum, max(salary) as Maximum from engineers group by salary

D select deptname, min(salary) as Minimum, max(salary) as Maximum from engineers order by deptname

E None of these

B