Write query to generate serial number in single query?
SET @rownum:=0; // Variable Declearation
SELECT @rownum:=@rownum+1 AS id, <colName1>,<colName2> FROM <TableName>;
Showing posts with label Write query to generate serial number in single query?. Show all posts
Showing posts with label Write query to generate serial number in single query?. Show all posts
Thursday, March 15, 2018
Write query to generate serial number in single query?
SET @rownum:=0; // Variable Declearation
SELECT @rownum:=@rownum+1 AS id, <colName1>,<colName2> FROM <TableName>;
Subscribe to:
Posts (Atom)