select * from emp where empname like '%j%'

in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

Question Posted / muthu kumar

Answer Posted / muthu kumar

Is This Answer Correct ?

12 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the aggregate and scalar functions?

990

Explain the different index configurations a table can have?

885

Explain about nested stored procedure?

975

Explain how many types of relationship?

972

Explain about merge replications?

964

What is the correct order of the logical query processing phases?

873

What function does a database engine serve in the sql server?

985

What is an indexed view?

916

What is RAID? What are the different types of RAID configurations?

1063

Explain the disadvantages/limitation of the cursor?

915

What is the use of @@spid?

957

When would you use a before or after trigger?

858

How to trouble shoot if unable to connect SQL Server

1924

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

936

How much does sql server 2016 cost?

987