Answer Posted / sameera chiluka

select secondMAXsal from emp
WHERE seconMAXsal = ((MAXsal)-1);

How do I find sql server instance name?

963

---

How to turn off warning messages during php execution?

1044

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

922

---

How to integrate the ssrs reports in application?

990

---

Can select statements be used on views in ms sql server?

1065

---

What is difference between materialized view and view?

916

---

Do you know what is xpath?

1088

---

How real and float literal values are rounded?

1158

---

Which sql server table is used to hold the stored procedure script?

948

---

What is provisioning, billing and metering, and connection routing concepts in the service layer?

113

---

Can we join two tables without primary key?

1054

---

How to edit table in sql server 2017?

927

---

What part does database design plays a role in performance of an sql server-based application?

986

---

How to create a scrollable cursor with the scroll option?

999

---

What is change tracking in sql server?

1026

---