Answer Posted / pradip jain

Select * from marks where
(Math=(select min(Math)from
marks) and phy=(select min(phy) from marks))
OR
(Math=(select min(Math)from
marks) and chem=(select min(chem) from marks))
OR
(Phy=(select min(phy)from
marks) and chem=(select min(chem) from marks))


Sonia if it is 3 subject and will be combine with or clause

Can we call future method from queueable?

996

---

Explain what are commit and rollback in sql?

867

---

How do I completely remove sql server instance?

1026

---

Explain the truncate command?

920

---

What command is used to delete a table from the database in the sql server and how?

1043

---

What are sql dirty pages?

972

---

What is difference between stored procedure and user defined function?

1033

---

What is an index. What are the types?

1014

---

Explain primary key, foreign key and unique key?

936

---

What is a non clustered primary key?

877

---

If user is owning any SQL Objects, can we drop that user

2011

---

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2029

---

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

859

---

What is trigger explain with program?

935

---

What is report snapshot in ssrs?

247

---