Answer Posted / b.v.siva kumar

Use this for SQL Server:

select top 1 salary from emp where salary in (select
distinct top 3 salary from emp order by salary desc) order
by salary

What is left join in sql?

1003

---

how to check myisam tables for errors? : Sql dba

1256

---

What are the rules to be applied to nulls whilst doing comparisons?

1271

---

What are the possible values that can be stored in a boolean data field?

945

---

What port does sql server use?

985

---

What are all the different normalizations?

968

---

what are the different type of normalization? : Sql dba

968

---

how is myisam table stored? : Sql dba

996

---

how many sql dml commands are supported by 'mysql'? : Sql dba

1053

---

Who developed sql?

958

---

what is query cache in mysql? : Sql dba

990

---

what is a database? : Sql dba

1097

---

What are different types of sql commands?

1022

---

explain mysql aggregate functions. : Sql dba

939

---

Why join is faster than subquery?

1040

---