Friday, May 15, 2020

SQL DATABASE BASIC QUERIES

SQL DATABASE BASIC QUERIES


SQL query for getting record using like keyword with multiple values? | Get Multiple Records with Like Query | Using Like query Get Multiple Records


//This the query will return which data having the first letter a, b

and z.

SQL COMMAND :

Select columnName From TableName Where columnName Like '[ABZ]%'


//This query will return A to Z which data having the first latter

 A B, C......... Z.

SQL COMMAND : 

Select columnName From TableName Where columnName Like '[A-B]%'


No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

SQL Server Unique Constraint

SQL Server Unique Constraint Whats is Unique Constraint in SQL | How to create Unique Constraint in SQL | Unique Constraint with Example in ...