select names starts with a,b,c
Answers were Sorted based on User's Feedback
Answer / lakshmi narayanan r
SELECT * FROM abc a WHERE a.ename LIKE '[a-c]%'
Is This Answer Correct ? | 19 Yes | 1 No |
Answer / prashant
SELECT NAMES FROM TABLE_NAME
WHERE NAME LIKE 'a%'
or NAME LIKE 'b%'
or NAME LIKE 'c%'
Is This Answer Correct ? | 16 Yes | 6 No |
Answer / naren
Lakshmi Narayanan u r correct.
But we can use the table only.
SELECT * FROM abc WHERE ename LIKE '[a-c]%'
I think its better...
Is This Answer Correct ? | 10 Yes | 2 No |
Answer / 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 |
Answer / 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 |
Answer / gopinath
SELECT NAMES FROM TABLE_NAME
WHERE NAME LIKE 'a%'
or NAME LIKE 'b%'
or NAME LIKE 'c%'
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / roopesh kumar
Select * From emp Where substr(ename,1,1) In
('a', 'b', 'c', 'S');
Is This Answer Correct ? | 1 Yes | 4 No |
Answer / naren
select * from table_name where Name like 'A%'
union
select * from table_name where Name like 'B%'
union
select * from table_name where Name like 'C%'
Is This Answer Correct ? | 6 Yes | 10 No |
Does the unique constraint create an index?
Do you know hot add cpu in sql server 2008?
When multiple after triggers are attached to sql table, how to control the order of execution?
How do you use a subquery to find records that exist in one table and do not exist in another?
What are indexes? When do you need to create Indexes?
4 Answers CarrizalSoft Technologies, HP,
The Difference between 'Count' and 'Count(*)'
What is a transact-sql statement batch in ms sql server?
What is the default value of CHAR type?
Does an index slow down updates on indexed columns?
What is normalization of database? What are its benefits?
what are the limitations of parameters in a storedprocedure
What is built-in function?