how can we know the number of days between two given dates using mysql? : Sql dba

0 Answers  

---

Does indexing improve query performance?

1 Answers  

---

What is a bitmap index?

4 Answers   Choice Solutions, Infosys,

---

What are the advantages of normalization?

0 Answers  

---

What does where 1/2 mean in sql?

0 Answers  

---

Delete the emps whose salaries are lowest sals of their own dept.

5 Answers  

---

How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)

3 Answers   TCS,

---

table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

2 Answers   Maruti Suzuki,

---

Mention what does the hierarchical profiler does?

0 Answers  

---

What is Collation Sensitivity ? What are the various type ?

0 Answers  

---

Does SQL*Plus contains pl/sql Engine?

1 Answers   TCS,

---

How does postgresql compare to oracle/db2/ms sql server/informix?

0 Answers  

---