Answer Posted / deepak dabi

I Think this is the best solution ever i have seen ,i
appriciate if you prove me wroong on this so,otherwise i got
all other a bit wrong ,in many cases please try this....



"SELECT distinct(sal) from emp order by sal desc limit 2,1"

What are the built in functions in sql server?

1030

---

How to execute multiple stored procedures at one time in sql server?

1067

---

what happens on checkpoint? : Sql server database administration

1158

---

What is master database? : SQL Server Architecture

1083

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

1099

---

What are the various editions of sql server 2017 that are available in the market?

940

---

What is the function of inner join?

1127

---

Explain isolation levels that sql server supports?

1084

---

Explain indexed views?

1031

---

What are the purposes and advantages stored procedure?

1020

---

How to download and install microsoft .net framework version 2.0?

1184

---

Explain different types of lock modes in sql server 2000?

984

---

What is the difference between getdate and sysdatetime?

1065

---

Can you explain the disadvantages/limitation of the cursor?

1055

---

How much space does sql server 2016 take?

1033

---