Interested to Buy Any Domain ? << Click Here >> for more details...
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 is a relationship and what are they?
Can we use having without group by in sql?
What is varchar used for?
Does sql between include endpoints?
How would you reference column values before and after you have inserted and deleted triggers?
Explain architecture of sql server notification services?
What is pl sql in oracle?
How many parts of a pl sql block are optional?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
What is sequence in sql?
What are the features of pl sql?
What is the difference between cross join and natural join?
what is the command line end user interface - mysql? : Sql dba
What is sql integrity?
Explain select statements in sql?
