Question { Semantic Space, 6522 }

which clause we are not used in where clause?

Answer

WE can use group by clause in where clause.
For Ex: SELECT column_name, aggregate_function(column_name)
FROM table_name
WHERE column_name operator value
GROUP BY column_name

We can't use case statement in where clause.

Question { Polaris, 13803 }

One Table having two rows with one colomn having values
Like"Male" and "Female". how to upadte these values
Like "Female" and "Male" in single update statement.

Answer

'DECODE' is not a recognized built-in function name in sql
server

Question { Sasken, 6615 }

when we use the static methods

Answer

if you want to share a method to whole application without
creating instence for that class,we can use static keyword
to method.

Question { 5883 }

WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT
AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A
COLUMN ?
INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN.
WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE
ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS
NULL VALUES.

Answer

By default primary key maintain clusterd index,All the
records are stored in stored order.By takeing this
advantage query will be execute fast.

Unique maintain nonclusted index,All the records are not in
stored order.