Answer Posted / gvmahesh

I write the query for this question using OLAP functions.

select e1.* from (select ename,sal,rank()
over(order by sal desc) rank from emp) e1
where e1.rank=2;

how to create a test table in your mysql server? : Sql dba

946

---

Can a table have no primary key?

1011

---

What is difference between procedure and trigger?

919

---

What is a relationship and what are they?

1050

---

Explain what is a database?

1039

---

What is db journal file?

956

---

Enlist the advantages of sql.

939

---

What is a unique constraint?

1016

---

What is sqlca in db2?

895

---

What is lexical units in pl sql?

1054

---

How do I sort a table in sql?

983

---

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3946

---

What are string functions in sql?

1174

---

What are the different types of database management systems?

951

---

what are date and time intervals? : Sql dba

999

---