Answer Posted / raghunanda

SELECT * FROM(SELECT * FROM EMP ORDER BY SAL DESC) WHERE ROWNUM<=3;

How to rename a table?

1076

---

What is sql not null constraint?

1096

---

Why do we need databases?

1093

---

what is a trigger in mysql? Define different types of trigger. : Sql dba

1121

---

what does the t-sql command ident_incr does? : Transact sql

1125

---

What is the use of count (*) in sql?

1119

---

What is the difference between nvl function, ifnull function, and isnull function?

1157

---

Does truncate release storage space?

1137

---

What is structural independence and why is it important?

1074

---

Explain sql data types?

1145

---

What is the difference between functions, procedures, and packages in pl/sql?

1096

---

What is gpt format?

993

---

What is the use of desc in sql?

1022

---

What is a database event trigger?

1213

---

How does one load ebcdic data? : aql loader

1258

---