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 is the difference between cartesian product and cross join?

905

Differentiate between a primary key and a unique key.

1119

Why are sql functions used?

1184

What are the various editions of sql server 2017 that are available in the market?

940

What are pages and extents? : SQL Server Architecture

1072

Difference between report and query parameter.

1144

How many types of subqueries are there in sql server?

1034

How to execute function in stored procedure sql server?

1235

Does index slows down insert statements?

1047

What is the difference between a stored procedure and a user defined function?

1066

What are trace flags?

1086

How and why use sql server?

1063

What are the different Authentication modes in SQL Server and how can you change authentication mode?

1128

How to connect to SQL Azure Database by using sqlcmd?

140

Where the sql logs gets stored?

1035