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 download microsoft sql server 2005 express edition?

975

Explain what is raid and what are different types of raid levels?

949

What is the difference between dropping a database and taking a database offline?

1116

What is acid mean in sql server?

1036

How self join is different from outer join?

1061

What is collation sensitivity?

986

Which data type columns are the best candidates for full-text indexing?

917

What command must you use to include the not null constraint after a table has already been created?

1051

How connect excel to sql server?

929

What is ms sql server index?

1024

What is triggers in ms sql server?

1049

What stored by the msdb?

953

What is nonclustered index with included columns ?

906

What is database white box testing?

1077

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

997