Answer Posted / sunil bisht

Last 10 record from emp table

select * from emp where rowid<=(select max(rowid) from emp)
minus select * from emp where rowid in(select rowid from
emp where rownum<=3);

What is sql analyzer?

962

---

Can we join same table in sql?

964

---

Explain what is table in a database?

1009

---

What is the use of procedures?

926

---

Explain the difference between sql and mysql.

1003

---

What are tables in sql?

999

---

what is the difference between group by and order by in sql? : Sql dba

1061

---

Can we use rowid as primary key?

944

---

how to get a list of indexes of an existing table? : Sql dba

916

---

Can a varchar be a primary key?

955

---

Can we enter data in a table in design view?

913

---

What is trigger in pl sql?

959

---

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

988

---

Which nosql database is best?

929

---

what is innodb? : Sql dba

1034

---