Answer Posted / karna

Hi Friends,

to get the nth highest value of a column in a table,please
use the below simple query

select min(column) from table where column in(select top n
column from table)

any queries,mail me at karun84@gmail.com

Explain cursor types?

587

---

What are sql constraints?

570

---

How to install oracle sql developer?

573

---

Why are sql stored procedures used?

621

---

What is query execution plan in sql?

575

---

---

how to get a list of all tables in a database? : Sql dba

513

---

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

624

---

what are the advantages of mysql in comparison to oracle? : Sql dba

533

---

Why is theta join required?

671

---

Explain the uses of a database trigger?

579

---

Can we call a function containing dml statements in a select query?

548

---

Mention what is the plv (pl/vision) package offers?

643

---

What does select * from mean in sql?

2003

---

how many tables will create when we create table, what are they? : Sql dba

549

---

How to rename a column in the output of sql query?

539

---