table: employee; column name: lastname select * from employee where last

Selet all the data from table where last name is n of
employee

Question Posted / saurav kumar

Answer Posted / saurav kumar

table: employee; column name: lastname

select * from employee where lastname like '%n'

Is This Answer Correct ?

29 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to change parameter value inside the report?

158

What does the on delete cascade option do?

978

What is the difference between primary key and unique constraints?

923

What is use of attributehierarchyenabled? : sql server analysis services, ssas

1183

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

965

What does indexation mean?

930

How to use subqueries with the in operators in ms sql server?

1030

What is bookmark link in ssrs?

236

application server is slow what may be the problem

2183

Explain about nested stored procedure?

993

Explain “@@rowcount” and “@@error” in sql server?

1024

What is constraints and its types?

892

How you can get a list of all the table constraints in a database?

923

What is the name of the Database which IBM mainframe uses?

959

How to create an multi-statement table-valued function?

953