Answer Posted / kishore.p

select top 1 * from tblemp b where b.empsal not in(select
top n-1 empsal from tblemp e)

note:- here the n will be the number of only row you would
like to display.

here in the above case n=2 i.e., n-1=1

so this will be the querry:

select top 1 * from tblemp b where b.empsal not in(select
top 1 empsal from tblemp e)

what happens if null values are involved in expressions? : Sql dba

1029

---

What is normalisation in sql?

1041

---

Which is better stored procedure or query?

949

---

What are the types of sql commands?

1075

---

What is column?

975

---

What are stuff and replace function?

1065

---

how can we destroy the session, how can we unset the variable of a session? : Sql dba

981

---

What is denormalization in a database?

1030

---

What is difference between sql and oracle?

1099

---

What is procedure explain with example?

939

---

Define join and name different types of joins?

988

---

what are dynamic queries in t-sql? : Transact sql

1004

---

What is the difference between a query and a report?

950

---

How does rowid help in running a query faster?

1402

---

Describe different types of general function used in sql?

1016

---