sql query to get zero records from a table having n no of
records

Answer Posted / giri

Select * From Table_Name Where 1 = 2;

Is This Answer Correct ?    12 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is having clause in sql?

712


what is meant by urlencode and urldocode? : Sql dba

766


What are secondary keys?

733


How to get unique records from a table?

679


What is right join in sql?

739






What is difference between procedure and trigger?

666


Write a sql query to get the third highest salary of an employee from employee_table?

827


what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

700


How show all rows in sql?

793


What is data profiling in sql?

733


How many clustered indexes can you have?

726


How can I make sql query run faster?

750


How many row comparison operators are used while working with a subquery?

749


What is the location of pre_defined_functions.

837


What is t-sql? : Transact sql

708