Answer Posted / nishi.swain@gmail.com
select distinct sal from table_name t1 where 4=(select count(distinct sal) from table_name t2 where
t1.sal<=t2.sal);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the different type of joins in sql?
What is the difference between function, procedure and package in pl/sql?
What is pls_integer in pl sql?
Does truncate remove indexes?
Can we create index on primary key?
what is the stuff function and how does it differ from the replace function? : Sql dba
Can we join more than 2 tables in sql?
Can you call pl/sql package functions from within a fast formula?
What is a schema sql?
What are sql data types?
What are the types of queries in sql?
how can we know the count/number of elements of an array? : Sql dba
how to convert dates to character strings? : Sql dba
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
What is the difference between database trigger and stored procedure?
