Answer / ram

many number of tables can be join in a sql query by using 'join'

Answer / jo

In where clause u can write 254 subqueries and in from
clause u can write n number of queries

Answer / sumit

its 256

Answer / o.sridevi

many number of tables can create but not at a time one after one

how do you know if your mysql server is alive? : Sql dba

0 Answers  

---

How do you handle exceptions. Give the syntax for it?

1 Answers   BCL, Microsoft,

---

what is ref cursor in pl/sql?

3 Answers  

---

what are the security recommendations while using mysql? : Sql dba

0 Answers  

---

What is error ora-12154: tns:could not resolve the connect identifier specified?

0 Answers  

---

---

Difference between truncate, delete and drop commands?

0 Answers  

---

What is the sql query to display the current date?

0 Answers  

---

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE, Its some urgent requirement ,thanks in advance

6 Answers  

---

Explain the rollback statement?

0 Answers  

---

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

0 Answers  

---

Is postgresql a server?

0 Answers  

---

How to revise and re-run the last sql command?

0 Answers  

---