Interested to Buy Any Domain ? << Click Here >> for more details...
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
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
what is innodb? : Sql dba
How do you define a foreign key?
What does (*) mean in sql?
What is a scalar value in sql?
how to fetch alternate records from a table? : Sql dba
Does pdo prevent sql injection?
How to sort the rows in sql.
What are sql objects?
What are the types of subqueries?
What steps server process has to take to execute an update statement?
What are the types of index in sql?
How many joins in sql?
How do you modify a column in sql?
What is the basic form of sql query?
