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

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 / aparna sanas

Answer Posted / aparna sanas

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

Is This Answer Correct ?

10 Yes

6 No

Please Help Members By Posting Answers For Below Questions

How to find table changes in sql server?

1049

Explain partitioned view?

1020

Explain what is the purpose of sql profiler in sql server?

1008

What are the steps you can take to avoid “deadlocks”?

919

What languages bi uses to achieve the goal?

947

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

843

What are the new security features added in sql server 2012? : sql server security

947

How to verify a login name with sqlcmd tool?

1135

What are sub reports and how to create them?

124

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

904

When does a workload on SQL Azure get throttled?

129

What is instead of dml trigger?

950

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

912

Explain about sql server login?

1026

Explain indexed views and partitioned view with their syntax.

1076