Tech with Hema

In sql server, what would be the result of the below query?

Given table Employees:

FIRST_NAME
Hema
Geetha
Viji
Saranya

SELECT STRING_AGG(FIRST_NAME, ',')
WITHIN GROUP (ORDER BY FIRST_NAME) AS FIRST_NAME
FROM EMPLOYEES

1 year ago | [YT] | 10

Tech with Hema

In sql server, what is the purpose of this below query?

SELECT TOP 1 salary
FROM(
SELECT TOP 3 salary
FROM employees
ORDER BY salary DESC)e
ORDER BY salary ASC

1 year ago | [YT] | 9

Tech with Hema

In sql server, will the below query to list the departments that has average salary greater than "10,000", renders expected result?

SELECT DEPARTMENT_ID, AVG(SALARY) as avg_salary
FROM employees
GROUP BY DEPARTMENT_ID
WHERE AVG(SALARY) > 10000

1 year ago | [YT] | 10

Tech with Hema

In SQL Server, what would be the result of the below query?

SELECT COALESCE('NULL', 'TECHNOLOGY', NULL)

1 year ago | [YT] | 4

Tech with Hema

In SQL server, what will be the number of rows of the result of the below query?



select * from tableA a
join tableB b
on a.id = b.id



Given:


tableA
col - id
1
1
2
3


tableB
col – id
2
2
1
1

1 year ago | [YT] | 5

Tech with Hema

Given:

tableA
Col - Id


1
2
3


tableB
Col – Id


1
2
3
4


In SQL server, what will be the number of rows of the result of the below query?


SELECT * FROM tableA
CROSS JOIN
tableB

1 year ago | [YT] | 5

Tech with Hema

In SQL Server, which of the following commands is used to delete all the records in a table but still retain the structure of the table?

1 year ago | [YT] | 7

Tech with Hema

In SQL server, which of the following is used to combine the result set of two or more select statements without any duplicates?

1 year ago | [YT] | 1