sql query to get zero records from a table having n no of
records
- 8 Answers
- 23291 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / abburi
select *from table_name where 1=2;
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Can we rollback truncate?
How many unique keys can a table have?
What is normalization sql?
what is bcp? When is it used?
What is delimiter in pl sql?
What is serial sql?
Do we need to create index on primary key?
What is difference between primary and secondary key?
Is inner join same as self join?
What is substitution variable?
what is rollback? : Sql dba
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 are the different dml commands in sql?
What is crud sql?
What is scalar function?
