adspace


Explain where clause?

Answer Posted / Madhu Sudan Sharma

The WHERE clause in SQL is used to filter records based on specified conditions. It allows you to select only the records that meet certain criteria.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does view occupy space?

1021


What is the difference between upgrade and migration in sql server?

1185


When should you use an instead of trigger?

1054


How do I find query history in sql server?

1025


What are the properties of the transaction?

1074


Where can you add custom error messages to sql server?

1215


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2296


What is a coalesce function?

1285


How efficient you are in oracle and SQL server?

1258


How to convert character strings into numeric values?

1192


Why and when do stored procedure recompile?

1064


What is a view in sql?

1043


What is normalization and what are the advantages of it?

1057


How can you append an identity column to a temporary table?

1071


Explain “row_number()” in sql server with an example?

1080