Answer Posted / gopi mandadi

Select emp_no,name,dept,sal from emp_t A
Where &n = (Select sal from emp_t B Where A.sal <= b.sal)

Describe how to use the linked server?

1204

---

Can you force a query to use a specific index?

993

---

What are the security related catalog views? : sql server security

992

---

How to Update from select query in sql server?

1123

---

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

1124

---

What is create command?

1022

---

Describe and explain about SQL native client?

1159

---

What is the difference between locking and multi-versioning?

1041

---

What are differences in between sql server 2012 and sql server 2016?

1098

---

What is the difference between coalesce() & isnull()?

1192

---

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

1031

---

Different types of keys in SQL?

1147

---

how to control the amount of free space in your index pages? : Sql server database administration

1087

---

How to find index size for each index on table?

1056

---

What is the order by used for?

1058

---