select names starts with a,b,c
Answer Posted / senthil
SELECT NAMES FROM TABLE_NAME
WHERE lower(NAME) LIKE 'a%'
or lower(NAME) LIKE 'b%'
or lower(NAME) LIKE 'c%';
Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
What is a matrix in ssrs?
Are all views updatable ?
What are different types of views?
What does it mean to normalize a database and why would you do it?
Do you have any idea about the tcl commands?
What is clustered primary key?
What is self contained multi valued query?
What is the default value of an integer data type in sql server 2005?
What does ss stand for sexually?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What are sql server functions?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
What is service broker?
What is partitioned view?
Define outer join in sql server joins?