select names starts with a,b,c
Answer Posted / rajkumar v
SELECT * FROM TABLE_NAME WHERE Colum_Name LIKE '[a-c]%'
OR
SELECT * FROM TABLE_NAME WHERE Colum_Name LIKE '[a,b,c]%'
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What are the parts of a function?
List some advantages and disadvantages of stored procedure?
What is collation sensitivity? Explain different types.
Please explain go command in sql server?
What is trace flag in sql server?
Can you pass expressions to stored procedure parameters?
What is the impact on other user sessions when creating indexes?
What is 2nf example?
What happens if null values are involved in boolean operations?
What is a data collection table?
How can you hide the sql server instances?
What are various ways to enhance the ssrs report?
What is sql server database?
What is normalization of database? What are its benefits?