1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES;

2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES;

ouput should be in table format

Question Posted / saqifriends

2 Answers
13633 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest ..

Answer / aparna sanas

true Output will come in table format in single row and single
column

Is This Answer Correct ?

10 Yes

6 No

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest ..

Answer / sandeep modapathi

select sum(Gross_Salary),sum(Highest_Salary) from (

SELECT SUM(Salary) as Gross_Salary,0 as Highest_Salary from
EmpSalaryDetails
UNION
SELECT 0,MAX(Salary) from dbo.EmpSalaryDetails
) as rowset

Is This Answer Correct ?

5 Yes

1 No

Post New Answer

More SQL Server Interview Questions

What is the contrast amongst drop and truncate?

0 Answers

What is an identity?

0 Answers

What are the filtered indexes?

0 Answers

Can you tell me some of the common replication dmv's and their use? : sql server replication

0 Answers

Explain the difference between delete,drop and truncate in SQL Server?

0 Answers HCL,

What are the types of indexes?

0 Answers

Hi SQL gurus, i am working for an MNC... My team is having a problem in sql server. when user slects date prompts from jan 1st to april 30, it should display all months data like : jan aa feb bb mar cc but when it comes to april its taking data like : jan aa feb bb mar cc apr dd...and so on means its taking data again from jan to april which we dont want. we want the data only april month as we are getting jan, feb and mar... can any one write the code to relsove the issue please would be greatful if you can send to shiva_sans@yahoo.co.in and also please send your email also ...so that we will be in touch for any kind of queries ... Thanks a lot in Advance !!!

1 Answers

internal language used in sql server 2000?

2 Answers

What is a primary index?

0 Answers

what is the maximum size of a row in sql server 2000 and 2005

2 Answers

How to use “drop” keyword in sql server and give an example?

0 Answers

What is store procedure? How do they work?

0 Answers

For more SQL Server Interview Questions Click Here