Answer / Vijendra Sharma

Here is an example SQL query that generates a salary slip for a given employee with the specified format:nn```sqlnCREATE TABLE SalarySlip (Month VARCHAR(9), Amount INT);nnINSERT INTO SalarySlip VALUES ('Jan', 1000),n('Feb', 2000),n...n('Dec', 12000);nnSELECT CONCAT('Month: ', Month, 'nAmount: ', Amount) FROM SalarySlip;```

wtite down triggr not any entry on Sunday

2 Answers   NIT,

---

how are mysql timestamps seen to a user? : Sql dba

1 Answers  

---

Explain normalization and what are the advantages of it?

1 Answers  

---

HOW TO PRINT * ** *** **** ***** BY USING SQL QUERY? (MAY BE USING SCRIPT)

8 Answers   BeBo Technologies,

---

How to export the table data (this table having 18 million records) to .csv file. Please tell me is there any faster way to export the data.

8 Answers  

---

What is the difference between delete, truncate and drop command?

1 Answers  

---

How does left join work in sql?

1 Answers  

---

What are character functions?

1 Answers  

---

define sql update statement ? : Sql dba

1 Answers  

---

How do I write a cron which will run a sql query and mail the results to agroup?

1 Answers  

---

Is a table valued function object?

1 Answers  

---

Can we use insert statement in function?

1 Answers  

---