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 the difference between the sql*loader and import utilities? : aql loader
Is record in oracle pl sql?
How do you truncate?
How can we make an if statement within a select statement?
What is recursive join in sql?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
Describe different types of general function used in sql?
How many types of triggers exist in pl/sql?
how to use 'mysql' to run sql statements? : Sql dba
how many sql dml commands are supported by 'mysql'? : Sql dba
What is foreign key and example?
What is varray in pl sql?
what is top in tsql? : Transact sql
What is the difference between microsoft access and sql server?
Can we use join in subquery?
