Skip to content
Home » sql interview questions

sql interview questions

SQL Server ROW_NUMBER()

SQL Row_Number() is a ranking function/window function that is used to assign a sequential integer to each row within a partition of a result set. The row number starts with one for the first row in each partition.

 1,725 total views,  1 views today

How to access a data of table from another database in SQL Server?

How to copy a data of table from another database in SQL Server?

Suppose, you have a database1 and table1 and one another database2 and table2  in SQL server.

Now you are required to select data of a table1 of database1 from database2 of table2.

What would be a query for that?

 20,444 total views,  13 views today