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
13745 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 native system stored procedure to execute a command against all databases?

0 Answers

hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.

4 Answers

Explain acid?

0 Answers

Explain alternate key, candidate key and composite key in sql server?

0 Answers

What is an index in a database?

0 Answers

How to define and use table alias names in ms sql server?

0 Answers

Tell me what are cursors and when they are useful?

0 Answers

You are doing log shipping due to some reasons it is failing. How you will proceed from there

0 Answers

What is SubQuery in SQL Server 2008

0 Answers HCL,

Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 Answers

sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??

2 Answers

What are the system database in sql server 2005?

0 Answers

For more SQL Server Interview Questions Click Here