Answer Posted / sasikala

select max(salary) from emp where salary<(select max(salary) from emp);

What are the rendering extensions of ssrs?

142

---

How is foreign key related to primary key?

916

---

What is resultset concur_updatable?

971

---

Detail about query optimizer?

1037

---

When you use @@error and try-catch?

988

---

How to get a list of columns using the "sys.columns" view in ms sql server?

920

---

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

991

---

What is a bit datatype?

927

---

How to create a view on an existing table in ms sql server?

1054

---

Do you know how to implement service broker?

887

---

What are the tables in sql?

1040

---

What is the purpose of update statistics and scope_identity() function?

1052

---

What does this statement do @@rowcount?

926

---

How global temporary tables are represented and its scope?

907

---

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

172

---