Answer Posted / tulasi ravi kumar

hi,
my id is ravi106109@gmail.com

select sal from emp a
where 1=(select count(b.sal) from emp b
where a.sal<b.sal) order by sal desc;

and also dileep is write

Can we update data in a view?

1081

---

Which is the main third-party tool used in sql server?

995

---

What is difference between rownum and rowid?

958

---

Which is faster statement or preparedstatement?

1003

---

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

1156

---

Explain transaction server isolation?

1085

---

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1268

---

What is etl - extraction, transformation, and loading?

961

---

Explain what is use of dbcc commands?

1136

---

Write a SQL command to insert and update only a particular field?

1193

---

What is field in algebra?

1095

---

Can you explain what is the use of custom fields in report?

1102

---

Difference between Logical Page and Physical Page in SSRS.

491

---

What do you understand by triggers?

979

---

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

1039

---