How do you assign Construct the where clause without concatenating Field,value

How do you assign Construct the where clause without
concatenating Field,value pairs?

Question Posted / guest

How do you assign Construct the where clause without concatenating Field,value pairs?..

Answer / soundara rajan. n

Can Construct With the Global Constants Ex.: 1=1

Is This Answer Correct ?

0 Yes

1 No

More SQL PLSQL Interview Questions

What is the maximum rows in csv?

How do I write a cron which will run a sql query and mail the results to agroup?

What is right join in sql?

What is a heap in sql?

Is sql similar to python?

how to dump a table to a file with 'mysqldump'? : Sql dba

i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL 9 10 11 12 NULL. I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.

Enlist some predefined exceptions?

What is the use of desc in sql?

What are the benefits of stored procedures?

write a query to delete similar records in different tables with same structure

Why trigger is used in sql?

For more SQL PLSQL Interview Questions Click Here