-
Retrieve Odd and Even Rows
How to retrieve odd and even number of rows from a table?
-
Maximum PK's and PI's
How many Primary keys and Primary Indexes can we create on a table.How many Foreign keys and Secondary indexes can we create on a table.How many maximum columns can we create in a table
-
Select 10 Random Records
How to write a query in SQL 2005 in order to Select 10 random records from table?
-
Rename a Column
How to rename a column in a SQL table?
-
Correlated subquery
display the 5th lowest sal from emp table using Correlated subquery
-
-
-