Answer Posted / jeevan

CREATE TABLE
[dbo].[Table_1]([ID] [int] NOT NULL,[SAL] [int] NULL)

//N=9
SELECT TOP 1 * FROM dbo.Table_1
WHERE ID NOT IN (SELECT TOP 8/*N-1*/ ID FROM dbo.Table_1
ORDER BY SAL DESC)
ORDER BY SAL DESC

What is a functions and types in sql server?

1150

---

What are tables in sql server?

1098

---

What is table valued function and scalar valued functions?

1166

---

What is create statement?

1010

---

What happens if the update subquery returns multiple rows in ms sql server?

1171

---

What is the beast way to write CTE in SQL Server ?

1096

---

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

1039

---

How adventureworkslt tables are related?

984

---

What is a View ? Can we insert, Update and delete a view?

1064

---

What programming language would you use to create embedded functions in ssrs?

191

---

What is a unique index?

974

---

Explain Normalization and DE normalization

1160

---

How to concatenate two binary strings together?

1175

---

What are the main differences between #temp tables and @table variables and which one is preferred?

1135

---

Which autogrowth database setting is good?

1096

---