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)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are different types of tables in sql?
how to increment dates by 1 in mysql? : Sql dba
Does sql profiler affect performance?
What are sql queries used for?
What are its different types of dbms?
What is the most restrictive isolation level? : Transact sql
how many ways to get the current time? : Sql dba
How much does sql cost?
What is a temporal table?
How to make a copy values from one column to another in sql?
Does sql backup shrink transaction log?
What is parameter substitution in sql?
What is difference sql and mysql?
What is difference between sql and mysql?
What is sql analyzer?
