Select * From emp Where substr(ename,1,1) In ('a', 'b'

select names starts with a,b,c

Question Posted / roopesh kumar

Answer Posted / roopesh kumar

Select * From emp Where substr(ename,1,1) In
('a', 'b', 'c', 'S');

Is This Answer Correct ?

1 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What are the advantages of stored procedure in sql server?

832

How to remove duplicate rows from table except one?

938

How to backup encryption key ?

167

What are statistics?

952

What is the order by used for?

965

Explain about Joins?

934

What are different types of data sources?

934

How to create a ddl trigger using "create trigger" statements?

1068

What are the different types of subquery?

1096

What is implicit cursors?

1001

what are constraints? Explain different types of constraints? : Sql server database administration

918

How to encrypt Strored Procedure in SQL SERVER?

1096

How do we synchronize On-Premise SQL server with SQL Azure?

120

What are the restrictions while creating batches in sql server?

1004

what are the new features in SSRS?

126