Answer / Varun Yadav

Microsoft SQL Server (MS SQL) and MySQL are both relational database management systems, but they have several differences. For example, MS SQL supports transactions at the statement level by default, while MySQL supports transactions at the commit level. Additionally, MS SQL has more advanced features for data integration, reporting, and analysis, whereas MySQL is known for its simplicity and ease of use.

What is the use of nvl function?

1 Answers  

---

What is difference between pls_integer and integer?

1 Answers  

---

how to sort records in sql?

3 Answers  

---

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance

5 Answers   Target,

---

What does over partition by mean in sql?

1 Answers  

---

How can you know that statistics should be updated?

1 Answers  

---

Why is theta join required?

1 Answers  

---

What is pl sql script?

1 Answers  

---

How do I view stored procedures?

1 Answers  

---

How can I make sql query run faster?

1 Answers  

---

What are sql built in functions?

1 Answers  

---

what are the advantages of primary key over unique+notnull

7 Answers   Consultancy, LGS, Oracle,

---