select names starts with a,b,c
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 |
Post New Answer View All Answers
How retrieve field names from the table in SQL through JAVA code?
What is normalization and what are the advantages of it?
How many levels of sp nesting are possible?
In which sql server version report builder introduced?
Explain transaction server distributed transaction?
What is the use of @@spid?
What is save transaction and save point?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
What is difference between clustered and non clustered index?
How can you start sql server in different modes?
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?
How to generate create view script on an existing view?
What is create statement?
How to find Duplicate Records In table?
What is the difference between dataadapter and datareader?