Skip to main content

Posts

Showing posts from November, 2008

Understanding Human Condition and Explanations in Terms of Natural and Computer Sciences

Understanding Human Condition and Explanations in Terms of Natural and Computer Sciences    A   Wittgensteinian Perspective Jatinder Kumar Sharma Deptt. of Philosophy, Punjabi University, Patiala. The relation of the human condition to the natural world and the nature of human agency has been hotly debated not only in Philosophy of mind and cognitive science literature but also in discussions pertaining to the methodology of various social sciences. After renaissance, due to success of natural sciences in explaining natural processes and events, upholders of methodological monism, followers of unity of science movement and more recently, people seeking grand synthesis in sciences by holding mind to be 'a system of organs of computation, designed by natural selection ' (Pinker, S., How the Mind Works, hereafter HMW, 21) i.e. proponents of New Synthesis Nativism, in various incarnations have endeavoured to understand human condition and vocabulary characteristic o

How to get Ramdom Row from Database

How to get Random Row from Database Select a random row with MySQL: SELECT column FROM table ORDER BY RAND() LIMIT 1 Select a random row with PostgreSQL : SELECT column FROM table ORDER BY RANDOM() LIMIT 1 Select a random row with Microsoft SQL Server: SELECT TOP 1 column FROM table ORDER BY NEWID() Select a random row with IBM DB2 SELECT column, RAND() as IDX FROM table ORDER BY IDX FETCH FIRST 1 ROWS ONLY Select a random record with Oracle: SELECT column FROM ( SELECT column FROM table ORDER BY dbms_random.value ) WHERE rownum = 1