Answer / Preetik Singh

"Rownum in SQL is an Oracle-specific pseudocolumn used to retrieve sequentially numbered rows returned by a query. It can be used for limiting the number of rows returned, sorting results, or skipping certain rows."

What are the types of join in sql?

1 Answers  

---

select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

2 Answers  

---

Types of indexes. What is the default key created when a primary key is created in a table ?

5 Answers   TCS,

---

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

1 Answers  

---

what is a composite primary key ? : Sql dba

1 Answers  

---

what are the methods using performance tunning in sql and pl/sql

2 Answers  

---

why sql is used as interpreter frequently rather than a compile?

1 Answers  

---

Is foreign key mandatory?

1 Answers  

---

how to do backup entire database? : Transact sql

1 Answers  

---

What are the benefits of triggers?

1 Answers  

---

How to select 10 records from a table?

1 Answers  

---

What are inner outer left and right joins in sql?

1 Answers  

---