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

What is 'write-ahead log' in sql server 2000 ?

804

How do I run a trace in sql server?

699

What is the minimum recommended amount of ram for sql server 2012 enterprise?

699

How to check table values in sql server?

704

Explain the different index configurations a table can have?

697

How each E-R model constructs can be mapped to the relational model?

734

What is RMS migrations?

1899

What is the purpose of sql profiler in sql server?

715

How can you insert values in multiple rows using one Insert statement?

811

What is sql server locking?

714

which table keeps the locking information? : Sql server administration

717

Is null vs coalesce?

647

What is the difference between DataRow.Delete() and DataRow.Remove()?

964

What is the difference between Normalization and De-normalization?

796

What is DCL?

770