Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / chandra sekhar
SELECT * FROM EMP e
where 3=(select count(*) from emp
where e.sal<=sal)
Using this correlated subquery we can easily get any one
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Why sql query is slow?
How many row comparison operators are used while working with a subquery?
What is an ndf file?
what is the use of friend function? : Sql dba
What is difference between stored function and application function?
What is t sql in sql server?
What is the difference between joins?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
Is pl sql useful?
Can we edit a view in sql?
Why we use joins in sql?
Can a key be both primary and foreign?
Name the different types of indexes in sql and define them.
Explain mutating table error.
What is the requirement of self-join?
