从sql表中的第二列生成数据. [英] generate data from 2nd column in a table in sql.

问题描述

我有一张桌子.现在我想从表的第二列生成数据.如何在sql中编写查询?
我不想从第一列开始.我想要从第二列开始

i have a Table. now i want generate data from 2nd column in a table. How to write query in sql?
i don''t want from 1st column.i want from 2nd column

推荐答案

从表名称中选择2nd_Column_namme.

Select 2nd_Column_namme from table Name.

SELECT * FROM
(
SELECT *,ROW_NUMBER() OVER(ORDER BY ID) AS 'RowRank' FROM TABLE1
) AS TABLE1 WHERE RowRank>1

尝试此语句&有趣的编码，亲爱的...

Try this statement & fun coding dear...

如果您的表包含id作为主键，那么..

if your table contains id as a primary key then..

select * from table1 where id!=(select top 1 id from table1)

这篇关于从sql表中的第二列生成数据.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！