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

How retrieve field names from the table in SQL through JAVA code?

1403

What is normalization and what are the advantages of it?

522

How many levels of sp nesting are possible?

557

In which sql server version report builder introduced?

105

Explain transaction server distributed transaction?

503

What is the use of @@spid?

575

What is save transaction and save point?

629

What is the difference between cube operator and rollup operator? : SQL Server Architecture

628

What is difference between clustered and non clustered index?

535

How can you start sql server in different modes?

509

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

564

How to generate create view script on an existing view?

563

What is create statement?

532

How to find Duplicate Records In table?

587

What is the difference between dataadapter and datareader?

543