1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / reddy

Answers were Sorted based on User's Feedback



in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jaga..

Answer / muthu kumar

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

Is This Answer Correct ?    12 Yes 1 No

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jaga..

Answer / ashok

select * from Emp where name like '%j%'

Is This Answer Correct ?    7 Yes 1 No

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jaga..

Answer / kalpana

select * from emp where name like '%J%'

Is This Answer Correct ?    5 Yes 1 No

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jaga..

Answer / 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

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jaga..

Answer / faridha

select * from emp where ename like 'J%' or '%J' and
not like ('arjun','jagadesh','niranjan','anju','aaaj');

Is This Answer Correct ?    0 Yes 1 No

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jaga..

Answer / ashok

select * from employee where name like=%'j'%

Thanx
Ashok

Is This Answer Correct ?    1 Yes 7 No

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jaga..

Answer / nithya_raghu

select * from emp where empname like J%

Is This Answer Correct ?    0 Yes 7 No

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jaga..

Answer / ashok

select * from employee where name like=%'j'%

Thanx
Ashok

Is This Answer Correct ?    0 Yes 7 No

Post New Answer

More SQL Server Interview Questions

How does clustered and non clustered index work?

0 Answers  

What are the aggregate and scalar functions?

0 Answers  

List some of the rules that apply to creating and using a ‘view’

0 Answers  

What are the different types of replication you can set up in sql server?

0 Answers  

What is a not null constraint?

0 Answers  




I have a website that allows customers to browse and place orders for certain products. I have 2 tables; Customers and Orders. The Customers table holds the customer records and the Orders table holds the orders placed by the customer. Both tables are tied based on the field Cust_ID. Example of the data is shown below: Cust_ID Cust_Name Cust_ID Product Amount Order_Date 1001 John Tan 1001 P-5211 $120.00 2/13/2006 1002 Michael Wong 1001 K-1428 $88.90 1/11/2006 1003 Mary Cheong 1003 C-0923 $82.50 1/27/2006 1004 Ahmad Suffian 1003 K-1428 $88.90 2/2/2006 Write a single SQL statement that extracts all purchase records with the following criteria: 1. Customer names starting with “M” only. 2. Orders placed within the current month only. 3. Amount does not exceed $100.00 The list must be sorted by order date with the latest order showing on top.

3 Answers   Techno Solutions,

What is the partitioning method?

0 Answers  

Why use identity in sql server?

0 Answers  

What is the purpose of the tempdb database?

0 Answers  

Define synonym?

0 Answers  

What are the advantages of paper records?

0 Answers  

What is difference between index and primary key?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories