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

What is self contained sub query?

1007

---

What is TDS(Tabular Data Stream) Gateway?

121

---

When is update_statistics command used?

1023

---

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

1569

---

What are unicode character string data types in ms sql server?

1218

---

Explain the xml support sql server extends?

1023

---

What are the purposes and advantages stored procedure?

931

---

Explain the difference between control flow and data flow?

975

---

Which table keeps information about stored procedures?

922

---

What are the kinds of subquery?

997

---

Difference between aggregate functions of sql?

1080

---

How to create an identity column?

1184

---

What is the cartesian product of the table?

943

---

How to create a ddl trigger using "create trigger" statements?

1109

---

Can we add our custom code in ssis?

972

---