SELECT * FROM TABLE_NAME WHERE EMP

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

Question Posted / anshu sharma

Answer Posted / anshu sharma

SELECT * FROM TABLE_NAME WHERE EMP_LASTNAME LIKE 'N%'

Is This Answer Correct ?

5 Yes

10 No

Please Help Members By Posting Answers For Below Questions

How to store and query spatial data?

1049

How many ways to create table-valued functions?

1057

What are indexes in ms sql server?

1120

What types of replication are supported in sql server?

1119

What is the importance of a recovery model?

1095

What are dml triggers and types of dml triggers?

1034

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

1052

what are the reporting service components in SSRS?

172

How to deploy the Report?

140

Differentiate between SQL and ORACLE joins and write their syntax.

1077

What is Service Broker in sql server 2012?

1078

What programming language would you use to create embedded functions in ssrs?

191

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1175

Differentiate between mongodb vs. Sql server?

1144

What do mean by xml datatype?

1179