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 get a list of table columns using the "sp_columns" stored procedure in ms sql server?

1017

What is ms sql server reporting services?

1060

Tell me what is de-normalization and what are some of the examples of it?

1056

Do you know data definition language, data control language and data manipulation language?

1045

What stored by the tempdb ? : sql server database administration

1058

What is Cross Join and in which scenario do we use Cross Join?

1015

How to create a large table with random data for index testing in ms sql server?

1034

How to execute the cursor queries with "open" statements?

1186

How to drop an existing stored procedure in ms sql server?

1035

Define primary key?

1143

What is a performance monitor?

977

Explain throw statement in sql server 2008?

1007

Do you know what is lock escalation?

1016

How to drop existing views from a database in ms sql server?

1107

What is compression - row-level and page-level compression?

921