at first i'm using datediff('d', a.due_date, current_date); but it takes too long to get the result but how can i subtract the current_date - a.due_date and still get the same result like when i use datediff? thank you

1 Answers  

---

What is the difference between b-tree and hash indexes?

0 Answers  

---

what is the size of date datatype in sql?

2 Answers  

---

Print 3 highest salary

9 Answers  

---

How many TRIGGERS are allowed in MySql table?

0 Answers  

---

What is foreign key in mysql?

0 Answers  

---

What are the 3 main types of search queries?

0 Answers  

---

Can we rename database in mysql?

0 Answers  

---

What is maximum size of a database in MySQL?

13 Answers   Bastioncoup, CIS, NM, V2 Solutions, Wipro,

---

Please suggest me any course and institute which provide training on the below skills. • Knowledge of data extraction concepts and tools • QMF (query management facility)queries • Experience and expertise in QMF queries • Excellent ability to write, read, and interpret QMF queries against the Source Data Warehouse base level (daily and monthly) and month-end affinity comp tables • RDBMS & ER • Knowledge of Relational Databases (RDBMS) and Entity Relationship (ER) Diagrams • SOURCE Data Warehouse • Experience and expertise in Source Data Warehouse or data warehouses on the mainframe. • MS SQL Server • Experience in MS SQL Server • Excellent skill in writing/interpreting SQL queries and running Data Transformation Services (DTS) or open query packages. • Knowledge of writing/interpreting Visual Basic code.

1 Answers  

---

How do you prevent MySQL from caching a query?

1 Answers  

---

Does insert statement lock the table?

0 Answers  

---