Answer Posted / pramod kumar behera

select level from dual connect by level <=10;

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1390

---

What is the difference between having and a where in sql?

1149

---

What is use of trigger?

984

---

What is the difference between sum and count in sql?

1034

---

List the various privileges that a user can grant to another user?

1090

---

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1113

---

tell us something about heap tables. : Sql dba

1136

---

What is pls integer?

1089

---

What are records give examples?

1050

---

What are aggregate functions in sql?

1225

---

Which sql statement is used to return only different values?

1053

---

what is the difference between where clause and having clause? : Sql dba

1042

---

What is the usage of when clause in trigger?

1087

---

how do you login to mysql using unix shell? : Sql dba

1124

---

Why trigger is used in sql?

1015

---