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

What are the dis_advantages of stored procedures, triggers, indexes?

2233

What is difference between equi join and inner join?

969

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2792

Write a sql query to get zero records from a table having n number of records?

1187

Is it possible to call a stored procedure within a stored procedure?

987

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1217

What are the advantages of using stored procedures in sql server?

1019

What are the benefits of normalization?

1120

Explain about sql server login?

1096

Define Unique Key?

1027

Explain transaction isolation levels in sql server?

1134

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

1120

What is TDS(Tabular Data Stream) Gateway?

121

Explain time data type in sal server 2008?

936

Equi join and non equi join is possible with sql server?

1031