SELECT * FROM TABLE_NAME WHERE 1 = 2;

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

Question Posted / welcomeashwin

8 Answers
25958 Views
CTS, I also Faced
E-Mail Answers

Answer Posted / welcomeashwin

SELECT * FROM TABLE_NAME WHERE 1 = 2;

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I quit sql?

956

what are all the different normalizations? : Sql dba

1038

What is sql select statement?

1030

What is dense_rank?

933

List the various privileges that a user can grant to another user?

1041

Explain ddl statements in pl/sql?

1009

Do ddl statements need commit?

969

what is the functionality of the function htmlentities? : Sql dba

960

What is the difference between stored procedure and view?

1017

What is sql table?

967

What is the use of & in pl sql?

1046

What is foreign key and example?

936

how to get a list of indexes of an existing table? : Sql dba

957

How we can update the view?

1049

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1580