In join, which clause in not used?
Answer Posted / b.kumar
--Ms sql server
We can't use where clause in joins(inner/left/right/full).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why are sql functions used?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
Explain the steps needed to create a scheduled job?
Will count(column) include columns with null values in its count?
What is difference between unique and primary key?
What Are the Main Features of SQL Azure?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
When do you think a developer should use sql server-based cursors?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
Explain how many normalization forms?
how would you troubleshoot blocking? : Sql server database administration
Can we use where clause with group by?
How is sql used in sql server?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
How many categories of functions based their return modes?