Answer Posted / manvar prajesh

select top 1 name,salary from emp where salary<(select
max(salary) from emp)order by salary desc

What is rank dense_rank and partition in sql?

972

---

explain the options of myisamchk to improve the performance of a table. : Sql dba

950

---

what are the advantages of using stored procedures? : Sql dba

1059

---

What are tables and fields?

973

---

What is left join in postgresql?

995

---

What is synonyms?

999

---

What is mdf ldf and ndf?

931

---

What is duration in sql profiler trace?

1021

---

Is not null in sql?

927

---

How many columns should be in an index?

902

---

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

1053

---

What are pl/sql cursor exceptions?

1036

---

What is the primary key?

877

---

what's the difference between a primary key and a unique key? : Sql dba

971

---

What is an emotional trigger?

930

---