Interested to Buy Any Domain ? << Click Here >> for more details...
in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
- 8 Answers
- 9662 Views
- I also Faced
- E-Mail Answers
Answer Posted / deepa
For those who names starts with letter J is
select * from emp where name like 'j%'
For those who names with letter J is
select * from emp where name like '%j%'
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
What are the types of processing and explain each? : sql server analysis services, ssas
What is difference between rollback immediate and with no_wait during alter database?
What is set nocount on and what is set nocount off?
What command is used to create a database in the sql server and how?
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
Explain about protocol layer present in SQL server?
Does sql server 2000 full-text search support clustering?
How to define and use table alias names in ms sql server?
What is molap and its advantage? : sql server analysis services, ssas
Can a database be shrunk to 0 bytes, if not, why?
What are the advantages of mirroring?
How to create nested stored procedure?
Describe triggers features and limitations?
What is model database? : SQL Server Architecture
