Answer Posted / lalit

select name, sal from (select name,sal from emp where sal<(select max(sal) from emp) order by sal desc)where rownum=1;

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

984

---

How bulk collect improves performance?

944

---

Why do we go for stored procedures?

993

---

Is primary key an index?

944

---

What does (+) mean in sql joins?

1006

---

What has stored procedures in sql and how we can use it?

1013

---

What are different types of queries in sql?

1043

---

what is sub-query? : Transact sql

1038

---

what are numeric data types? : Sql dba

1000

---

How do I delete a trigger?

911

---

What is difference between joins and union?

1042

---

What are the uses of sysdate and user keywords?

1046

---

What are the types of optimization?

886

---

Can we call procedure in select statement?

970

---

how to create a new view in mysql? : Sql dba

890

---