Answer Posted / raj
for example if we take emp table, the query like this...
select a.sal from emp a where 4=(select count(distinct(b.sal))from emp b where a.sal<=b.sal)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we use pl sql in mysql?
Is it possible to sort a column using a column alias?
What is multiple columns?
what are the t string functions available in tsql? : Transact sql
How to combine two stored procedures in sql?
What are joins in sql?
How many disk partitions should I have?
Is sqlite good enough for production?
What is mutating error in pl sql?
Can a view be mutating? If yes, then how?
How many types of privileges are available in sql?
What is a sql schema used for?
What is sql indexing?
What is pl sql and why it is used for?
What is the difference between sql and t sql?