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 is error ora-03113: end-of-file on communication channel?
What is native sql query?
what is difference between delete and truncate commands? : Sql dba
What is auto increment feature in sql?
Which command is used to call a stored procedure?
Is it possible to link two groups inside a cross products after the cross products group has been created?
What jobs use sql?
What are the set operators in sql?
What is trigger explain it?
Is there a way to automate sql execution from the command-line, batch job or shell script?
Why stored procedures are faster than query?
Why function is used in sql?
How to find 3rd highest salary of an employee from the employee table in sql?
How sql query is executed?
Is left join inner or outer?