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 many bits ip address consist of? : Sql server database administration

847

When is update_statistics command used?

997

How to define output parameters in stored procedures?

959

What is the use of nvl work?

947

Explain rdbms?

980

Explain what is lock escalation and what is its purpose?

874

What are truncate options available in sql server? : sql server database administration

966

Name three of the features managed by the surface area configuration tool? : sql server security

944

How to restore performance issues and how to check?

1949

How many columns can we include on clustered index ?

924

Describe in brief databases and sql server databases architecture.

942

What are scheduled tasks in sql server?

1009

What is the command used to check locks in microsoft sql server?

972

Why are you getting errors when creating a new odbc dsn?

1166

What is the purpose of data source?

955