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

What is the difference between the application object and session object?

1127

What is 5nf in normalization form?

1046

Is INSTEAD OF trigger directly applicable to Table ?

1071

Can a table be created inside a trigger?

1014

what are the different types of replication you can set up in sql server? : Sql server database administration

1063

What new changes are being made in SQL Server?

1275

How to enter date and time literals in ms sql server?

1070

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

1127

How can we rewrite sub-queries into simple select statements or with joins?

1033

What is indexing in sql server with example?

1044

Explain concepts of analysis services?

1018

Explain how to use linked server?

1033

What is Dependency Injection and provide example?

1182

Explain iaas, paas and saas?

What are the differences between left join and inner join in sql server?

1157