How to generate a salary slip like
jan 1000 1000
feb 1000 2000
...
dec 1000 12000
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;```
| Is This Answer Correct ? | 0 Yes | 0 No |
wtite down triggr not any entry on Sunday
how are mysql timestamps seen to a user? : Sql dba
Explain normalization and what are the advantages of it?
HOW TO PRINT * ** *** **** ***** BY USING SQL QUERY? (MAY BE USING SCRIPT)
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.
What is the difference between delete, truncate and drop command?
How does left join work in sql?
What are character functions?
define sql update statement ? : Sql dba
How do I write a cron which will run a sql query and mail the results to agroup?
Is a table valued function object?
Can we use insert statement in function?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)