Answer / sunita

select * from tab
where rownum=2;

What is a primary key called that is made up of more than one field?

0 Answers  

---

How to run sql statements through the web interface?

0 Answers  

---

What is the file extension for sql database?

0 Answers  

---

How to access the current value and next value from a sequence?

6 Answers  

---

What is posting?

0 Answers  

---

---

Why we use pl sql?

0 Answers  

---

How to get employee name from employee table which is the fiveth highest salary of the table

20 Answers   Infosys, Rolta,

---

Question: Below is the table city gender name delhi male a delhi female b mumbai male c mumbai female d delhi male e I want the o/p as follows: male female delhi 2 1 mumbai 1 1 Please help me in writing the query that can yield the o/p mentioned above?

2 Answers  

---

Can we edit a view in sql?

0 Answers  

---

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

---

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

0 Answers  

---

What is the difference between an inner and outer join?

0 Answers  

---